(2) Another problem is i am catching systemdate which not showing in proper format.like showing in 14\09\2010 and i want in 14/09/2010.
(3) and lastone i used ajax for calender but calender not showing.....
please someone help me....i am sending both .aspx and codebehind page....
/-----------------------------------.aspxpage----------------------------------------/
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="InsertPage.aspx.cs" Inherits="InsertPage" Title="Untitled Page" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AjaxToolkit" %>
aaaaaaaaaaaaaaa |
| |
| | oncheckedchanged="Check1_CheckedChanged" /> |
| | oncheckedchanged="Check2_CheckedChanged" /> |
runat="server" Format="dd/MM/yyyy" TargetControlID="txtvehiclereqdon"> | ||||
runat="server" Width="119px"> | ||||
runat="server" Width="119px"> | runat="server" Width="119px"> | |||
runat="server" Width="119px"> | ||||
runat="server" Width="119px"> | runat="server" Width="119px"> |
| BorderColor="#6699cc" BorderStyle="None" ForeColor="White" Width="77px" Text="APPLY" OnClick="btnSubmit_Click" /> |
/-----------------------------------codebehind page---------------------------------------/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using VehicleFormApp.library;
public partial class InsertPage : System.Web.UI.Page
{
string sCompany = "MEH";
string sLocation = "RNC";
string scheck1 = "";
string scheck2 = "";
string sEmpCode = "022234";
string sname = "";
string sdesignation = "";
string sdepartment = "";
string svehicle_reqd_on = "";
string sfrom_hours = "";
string sto_hours = "";
string svisit_place = "";
string svehicle_rpt_person = "";
string svehicle_rpt_location = "";
string spurpose = "";
string svehicle_no = "";
string sdriver_name = "";
string sdeparture_time = "";
string sdeparture_kms_reading = "";
string sarrival_time = "";
string sarrival_kms_reading = "";
string svisiting_area = "";
string sin_time = "";
string sout_time = "";
string sSubject = "";
string stringBody = "";
string sUrl;
string sFromemail = "";
string sTomail = "";
string homeurl = "";
library lib = new library();
protected void Page_Load(object sender, EventArgs e)
{
HtmlLink cssLink = new HtmlLink();
cssLink.Href = "VehicleFormApp.css";
cssLink.Attributes.Add("rel", "stylesheet");
cssLink.Attributes.Add("type", "text/css");
Header.Controls.Add(cssLink);
//Session["urlval"] = Request.QueryString["homeval"].ToString();
library lib = new library();
if (!IsPostBack)
{
string sMode = "";
if (Request.QueryString["MEH"] != null && Convert.ToString(Request.QueryString["MEH"]) != "")
{
sCompany = Request.QueryString["MEH"];
}
if (Request.QueryString["02260"] != null && Convert.ToString(Request.QueryString["02260"]) != "")
{
sEmpCode = Request.QueryString["02260"];
}
if (Request.QueryString["mode"] != null && Convert.ToString(Request.QueryString["mode"]) != "")
{
sMode = Request.QueryString["mode"];
}
if (sMode == "view")
{
DataTable dtviewdata = null;
dtviewdata = lib.ViewData(sCompany, sEmpCode);
if (dtviewdata != null)
{
lblSysDate.Text = dtviewdata.Rows[0].ItemArray[0].ToString();
lblofficial_veh.Text = dtviewdata.Rows[0].ItemArray[1].ToString();
lblprivate_veh.Text = dtviewdata.Rows[0].ItemArray[2].ToString();
lblempcode.Text = dtviewdata.Rows[0].ItemArray[3].ToString();
lblname.Text = dtviewdata.Rows[0].ItemArray[4].ToString();
lbldesignation.Text = dtviewdata.Rows[0].ItemArray[5].ToString();
ddrdepartment.SelectedValue = dtviewdata.Rows[0].ItemArray[6].ToString();
txtvehiclereqdon.Text = dtviewdata.Rows[6].ItemArray[7].ToString();
txtfrom_hour.Text = dtviewdata.Rows[0].ItemArray[8].ToString();
txtto_hour.Text = dtviewdata.Rows[0].ItemArray[9].ToString();
ddrvisit_place.Text = dtviewdata.Rows[0].ItemArray[10].ToString();
txtvehicle_rpt_person.Text = dtviewdata.Rows[0].ItemArray[11].ToString();
txtvehicle_rpt_location.Text = dtviewdata.Rows[0].ItemArray[12].ToString();
txtpurpose.Text = dtviewdata.Rows[0].ItemArray[13].ToString();
txtvehicle_no.Text = dtviewdata.Rows[0].ItemArray[14].ToString();
txtdriver_name.Text = dtviewdata.Rows[0].ItemArray[15].ToString();
txtdeparture_time.Text = dtviewdata.Rows[0].ItemArray[16].ToString();
txtdeparture_kms_reading.Text = dtviewdata.Rows[0].ItemArray[17].ToString();
txtarrival_time.Text = dtviewdata.Rows[0].ItemArray[18].ToString();
txtarrival_kms_reading.Text = dtviewdata.Rows[0].ItemArray[19].ToString();
ddrvisiting_area.SelectedValue = dtviewdata.Rows[0].ItemArray[20].ToString();
txtin_time.Text = dtviewdata.Rows[0].ItemArray[21].ToString();
txtout_time.Text = dtviewdata.Rows[0].ItemArray[22].ToString();
}
}
else
{
lblSysDate.Text = DateTime.Today.ToString("dd/MM/yyyy");
lblofficial_veh.Text = scheck1;
lblprivate_veh.Text = scheck2;
lblempcode.Text = sEmpCode;
DataTable dtname = lib.getUserDetail(sCompany, sEmpCode.Trim());
lblname.Text = dtname.Rows[0].ItemArray[0].ToString() + " " + dtname.Rows[0].ItemArray[1].ToString() + " " + dtname.Rows[0].ItemArray[2].ToString();
DataTable dtdesignation = lib.getEmpDesignation(sCompany, sEmpCode);
lbldesignation.Text = dtdesignation.Rows[0].ItemArray[0].ToString();
ddrdepartment.SelectedValue = sdepartment;
txtvehiclereqdon.Text = svehicle_reqd_on;
txtfrom_hour.Text = sfrom_hours;
txtto_hour.Text = sto_hours;
ddrvisit_place.Text = svisit_place;
txtvehicle_rpt_person.Text = svehicle_rpt_person;
txtvehicle_rpt_location.Text = svehicle_rpt_location;
txtpurpose.Text = spurpose;
txtvehicle_no.Text = svehicle_no;
txtdriver_name.Text = sdriver_name;
txtdeparture_time.Text = sdeparture_time;
txtdeparture_kms_reading.Text = sdeparture_kms_reading;
txtarrival_time.Text = sarrival_time;
txtarrival_kms_reading.Text = sarrival_kms_reading;
ddrvisiting_area.SelectedValue = svisiting_area;
txtin_time.Text = sin_time;
txtout_time.Text = sout_time;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
library lib = new library();
if (Request.QueryString["MEH"].ToString() == "MEH")
{
string strcur_date = lblSysDate.Text.Trim();
string strofficial_veh = Check1.Text.Trim();
string strprivate_veh = Check2.Text.Trim();
string strempcode = lblempcode.Text.Trim();
string strname = lblname.Text.Trim();
string strdesignation = lbldesignation.Text.Trim();
string strdepartment = ddrdepartment.SelectedValue.Trim();
string strvehiclereqdon = txtvehiclereqdon.Text.Trim();
string strfrom_hour = txtfrom_hour.Text.Trim();
string strto_hour = txtto_hour.Text.Trim();
string strvisit_place = ddrvisit_place.SelectedValue.Trim();
string strvehicle_rpt_person = txtvehicle_rpt_person.Text.Trim();
string strvehicle_rpt_location = txtvehicle_rpt_location.Text.Trim();
string strpurpose = txtpurpose.Text.Trim();
string strvehicle_no = txtvehicle_no.Text.Trim();
string strdriver_name = txtdriver_name.Text.Trim();
string strdeparture_time = txtdeparture_time.Text.Trim();
string strdeparture_kms_reading = txtdeparture_kms_reading.Text.Trim();
string strarrival_time = txtarrival_time.Text.Trim();
string strarrival_kms_reading = txtarrival_kms_reading.Text.Trim();
string strvisiting_area = ddrvisiting_area.SelectedValue.Trim();
string strin_time = txtin_time.Text.Trim();
string strout_time = txtout_time.Text.Trim();
lib.InsertData(strcur_date, strofficial_veh, strprivate_veh, strempcode, strname, strdesignation, strdeparture_time,strvehiclereqdon,strfrom_hour,strto_hour,strvisit_place,strvehicle_rpt_person,strvehicle_rpt_location,strpurpose,strvehicle_no,strdriver_name,strdeparture_time,strdeparture_kms_reading,strarrival_time,strarrival_kms_reading,strvisiting_area,strin_time,strout_time);
btnSubmit.Visible = false;
Sendmail objSendMail = new Sendmail();
//sUrl = "http://192.168.3.4/VehicleFormApp/InsertPage.aspx?";
sUrl += "empcode=" + strempcode + "&";
sUrl += "comcode=" + sCompany + "&";
sUrl += "mode=view";
if (strempcode != null)
{
DataTable dtuserempcode = new DataTable();
dtuserempcode = lib.getuseremail(sCompany, strempcode.Trim());
sFromemail = dtuserempcode.Rows[0].ItemArray[0].ToString();
sTomail = dtuserempcode.Rows[0].ItemArray[1].ToString();
if (sTomail != "")
{
DataTable dtusername = lib.getUserDetail(sCompany, sEmpCode.Trim());
string sFullName = "";
if (dtusername != null)
{
if (dtusername.Rows.Count > 0)
{
sFullName = dtusername.Rows[0].ItemArray[0].ToString() + " " + dtusername.Rows[0].ItemArray[1].ToString() + " " + dtusername.Rows[0].ItemArray[2].ToString();
}
}
sSubject = "Vehicle requisition Form - of" + sFullName + " " + DateTime.Now.ToString();
stringBody = stringBody + " ";
stringBody = stringBody + "";
stringBody = stringBody + "";
";
| "; stringBody = stringBody + "DEAR SIR / MADAM,"; stringBody = stringBody + " | ";||
| PLEASE CLICK HERE To Check the Vehicle Requisition Form Of " + sFullName + " | ";||
| REGARDS, |
stringBody = stringBody + "";
objSendMail.SendeMail(sCompany, sFromemail, sTomail, sSubject, stringBody);
lblMsg.Text = "Data Saved Successfully and Mail send to :-";
}
}
}
}
protected void Check1_CheckedChanged(object sender, EventArgs e)
{
CheckBox Check1 = sender as CheckBox;
if (Check1 != null)
{
if (Check1.Checked)
{
}
}
}
protected void Check2_CheckedChanged(object sender, EventArgs e)
{
CheckBox Check2 = sender as CheckBox;
if (Check2 != null)
{
if (Check2.Checked)
{
}
}
}
}
please help me....
lots of thanks.
Dipa AhujaPosted Sep 19, 2010, 1:02 PM