protected void btnSave_Click(object sender, EventArgs e)
{
clsWorkOrder obj;
foreach (GridViewRow dr in grd.Rows)
{
obj = new clsWorkOrder();
TextBox txtIssueDate = dr.FindControl("txtIssueDate") as TextBox;
TextBox txtCName = dr.FindControl("txtCName") as TextBox;
TextBox txtCAddress = dr.FindControl("txtCAddress") as TextBox;
TextBox txtCPhone = dr.FindControl("txtCPhone") as TextBox;
TextBox txtCEmail = dr.FindControl("txtCEmail") as TextBox;
TextBox txtSubject = dr.FindControl("txtSubject") as TextBox;
TextBox txtDetail = dr.FindControl("txtDetail") as TextBox;
FileUpload file = dr.FindControl("file") as FileUpload;
if (txtIssueDate.Text != "" && txtCName.Text != "")
{
obj.IssueDate1 = Convert.ToDateTime(txtIssueDate.Text).ToShortDateString();
obj.CName = txtCName.Text;
obj.CAddress = txtCAddress.Text;
obj.CPhone = txtCPhone.Text;
obj.CEmail = txtCEmail.Text;
obj.Subject = txtSubject.Text;
obj.Detail = txtDetail.Text;
obj.UploadedFile = UploadFile(file);
obj.Op = 1;
obj.WorkOrder(obj);
}
}
Option = 1;
LoadData(Option);
}
/*
* Op=1 insert data
* Delete Data
* Get Data By Date
* Search by CName
* Get All Data
* Get All Data by ID
*/
public DataSet WorkOrder(clsWorkOrder obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@IssueDate1", obj._IssueDate1);
param[2] = new SqlParameter("@IssueDate2", obj._IssueDate2);
param[3] = new SqlParameter("@CName", obj._CName);
param[4] = new SqlParameter("@CAddress", obj._CAddress);
param[5] = new SqlParameter("@CPhone", obj._CPhone);
param[6] = new SqlParameter("@CEmail", obj._CEmail);
param[7] = new SqlParameter("@Subject", obj._Subject);
param[8] = new SqlParameter("@Detail", obj._Detail);
param[9] = new SqlParameter("@UploadedFile", obj._UploadedFile);
param[10] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procWorkOrder", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
void LoadData(int Op)
{
clsWorkOrder obj = new clsWorkOrder();
switch (Op)
{
case 1:
obj.Op = 5;
break;
case 2:
try { obj.IssueDate1 = Convert.ToDateTime(txtDateFrom.Text).ToShortDateString(); }
catch { }
try { obj.IssueDate2 = Convert.ToDateTime(txtDateTo.Text).ToShortDateString(); }
catch { }
obj.Op = 3;
break;
case 3:
obj.CName = txtName.Text;
obj.Op = 4;
break;
default:
obj.Op = 5;
break;
}
DataTable dt = obj.WorkOrder(obj).Tables[0];
foreach (DataRow dr in dt.Rows)
{
if(dr["UploadedFile"].ToString().Trim()!="")
{
dr["UploadedFile"] = "~/" + dr["UploadedFile"].ToString().Trim();
}
dr["CAddree"] = dr["CAddress"].ToString().Replace("\n","<br>");
dr["Detail"] = dr["Detail"].ToString().Replace("\n", "<br>");
}
grdExisting.DataSource = dt;
grdExisting.DataBind();
foreach (GridViewRow dr in grdExisting.Rows)
{
dr.Cells[0].Text = Convert.ToDateTime(dr.Cells[0].Text).ToShortDateString();
}
}
