protected void cmdUpdateJob_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
pnlException.Visible = false;
string strRef = string.Empty;
string strJobTitle = string.Empty;
string strJobDesc = string.Empty;
int iAssgn = 0;
double dQtyAss = 0;
string strAssDate = string.Empty;
string strExpRetDate = string.Empty;
double dQtyRet = 0;
strRef = txtRefno.Text.Trim();
strJobTitle = txtJobTitle.Text.Trim();
strJobDesc = txtDesc.Text.Trim();
if (drpIncharge.SelectedIndex > 0)
{
iAssgn = Convert.ToInt32(drpIncharge.SelectedItem.Value);
}
dQtyAss = Convert.ToDouble(txtAssQty.Text.Trim());
strAssDate = txtAssignedDate.Text.Trim();
strExpRetDate = txtExpRetDate.Text.Trim();
dQtyRet = Convert.ToDouble(lblRetQty.Text);
int jobID = Convert.ToInt32(hdJobID.Value);
string isComp = "N";
/* Insert into the Job Table */
BusinessLogic bl = new BusinessLogic(sDataSource);
int jobid = bl.UpdateJobDetails(strRef, strJobTitle, strJobDesc, iAssgn, strAssDate, strExpRetDate, dQtyAss, dQtyRet, jobID, isComp);
ModalPopupJob.Hide();
UpdatePnlMaster.Update();
Reset();
GetJobDetails("0");
//pnlValidation.Visible = false ;
//lnkBtnAdd.Visible = true;
//pnlDetails.Visible = false;
gvJob.Visible = true;
tabs2.Visible = false;
//TabPanel1.Visible = false;
//MyAccordion.Visible = true;
//gvJob.Visible = true;
}
else
{
//pnlValidation.Visible = true;
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void lnkBtnAdd_Click(object sender, EventArgs e)
{
try
{
//MyAccordion.Visible = false;
ModalPopupJob.Show();
//pnlDetails.Visible = true;
//lnkBtnAdd.Visible = false;
cmdUpdateJob.Visible = false;
cmdSaveJobReturn.Enabled = true;
cmdSaveJob.Visible = true;
cmdSaveJob.Enabled = true;
//gvJob.Visible = false;
txtRefno.Focus();
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void cmdReset_Click(object sender, EventArgs e)
{
try
{
pnlException.Visible = false;
//cmdSaveJobReturn.Enabled = true;
//cmdSaveJob.Enabled = true;
//cmdUpdateJob.Enabled = false;
Reset();
ResetReturn();
//MyAccordion.Visible = true;
//pnlDetails.Visible = false;
ModalPopupJob.Hide();
//lnkBtnAdd.Visible = true;
//gvJob.Visible = true;
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void gvJob_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//lnkBtnAdd.Visible = false;
//pnlDetails.Visible = true;
ModalPopupJob.Show();
//MyAccordion.Visible = false;
pnlException.Visible = false;
//gvJob.Visible = false;
DataKey key = gvJob.SelectedDataKey;
int jobID = Convert.ToInt32(key.Value);
BusinessLogic bl = new BusinessLogic(sDataSource);
DataSet ds = bl.ListJobDetails(jobID);
string strCompleted = string.Empty;
if (ds != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
txtRefno.Text = Convert.ToString(dr["Ref"]);
txtJobTitle.Text = Convert.ToString(dr["JobTitle"]);
txtDesc.Text = Convert.ToString(dr["JobDesc"]);
strCompleted = Convert.ToString(dr["IsCompleted"]);
//drpIncharge.SelectedItem.Value = Convert.ToString(dr["AssignedTo"]);
drpIncharge.DataBind();
drpIncharge.ClearSelection();
ListItem li = drpIncharge.Items.FindByValue(Convert.ToString(dr["AssignedTo"]).Trim());
if (li != null)
{
li.Selected = true;
}
txtAssQty.Text = Convert.ToString(dr["Qty_Assigned"]);
txtAssignedDate.Text = Convert.ToDateTime(dr["AssignedDate"]).ToShortDateString();
txtExpRetDate.Text = Convert.ToDateTime(Convert.ToString(dr["ExpReturnDate"])).ToShortDateString();
lblRetQty.Text = Convert.ToString(dr["Qty_Returned"]);
hdJobID.Value = jobID.ToString();
if (strCompleted == "Y")
{
cmdSaveJob.Enabled = false;
cmdSaveJob.Visible = false;
cmdUpdateJob.Enabled = false;
cmdSaveJobReturn.Enabled = false;
gvJobReturn.Enabled = false;
gvJobReturn.Columns[3].Visible = false;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Selected Job is Completed you can just view the summary.');", true);
}
else
{
gvJobReturn.Enabled = true;
cmdSaveJobReturn.Enabled = true;
cmdSaveJob.Enabled = false;
cmdSaveJob.Visible = false;
cmdUpdateJob.Enabled = true;
cmdUpdateJob.Visible = true;
}
DataSet dsR = new DataSet();
dsR = bl.ListJobReturn(jobID);
if (dsR != null)
{
gvJobReturn.DataSource = dsR;
gvJobReturn.DataBind();
}
else
{
gvJobReturn.DataSource = null;
gvJobReturn.DataBind();
}
}
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void cmdSaveJobReturn_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
pnlException.Visible = false;
string strRemarks = string.Empty;
string strRetDate = string.Empty;
double dQtyRet = 0;
int jobID = 0;
int jobCompID = 0;
double QtyAss = 0;
strRemarks = txtRemarks.Text.Trim();
strRetDate = txtCRetDate.Text.Trim();
dQtyRet = Convert.ToDouble(txtCRetQty.Text);
jobID = Convert.ToInt32(hdJobID.Value);
if (txtAssQty.Text.Trim() != string.Empty)
{
QtyAss = Convert.ToDouble(txtAssQty.Text.Trim());
}
BusinessLogic bl = new BusinessLogic(sDataSource);
if (jobID > 0)
{
jobCompID = bl.InsertJobReturnDetails(strRemarks, jobID, dQtyRet, strRetDate, QtyAss);
System.Threading.Thread.Sleep(1000);
if (jobCompID == -1)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Qty. Returned Should not be greater than assigned');", true);
return;
}
DataSet ds = new DataSet();
ds = bl.ListJobReturn(jobID);
if (ds != null)
{
gvJobReturn.DataSource = ds;
gvJobReturn.DataBind();
}
double dRet = Convert.ToDouble(lblRetQty.Text);
dRet = dRet + dQtyRet;
lblRetQty.Text = dRet.ToString();
ResetReturn();
GetJobDetails("0");
gvJob.Visible = true;
tabs2.Visible = false;
//lnkBtnAdd.Visible = true;
//pnlDetails.Visible = false;
ModalPopupJob.Hide();
UpdatePnlMaster.Update();
//MyAccordion.Visible = true;
//gvJob.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Qty. Returned Successfully Saved');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Select the job before you return the qty.');", true);
}
//pnlValidation.Visible = false;
}
else
{
//pnlValidation.Visible = true;
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.Cookies["Company"] != null)
{
sDataSource = ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString();
}
if (!IsPostBack)
{
//txtRefno.Focus();
//MyAccordion.Visible = true;
//pnlDetails.Visible = false;
gvJob.PageSize = 8;
Reset();
GetJobDetails("0");
updatePnlPurchase.Update();
ModalPopupJob.Hide();
rvReturnDate.MinimumValue = System.DateTime.Now.AddYears(-100).ToShortDateString();
rvReturnDate.MaximumValue = System.DateTime.Now.ToShortDateString();
rvAssignedDate.MinimumValue = System.DateTime.Now.AddYears(-100).ToShortDateString();
rvAssignedDate.MaximumValue = System.DateTime.Now.ToShortDateString();
string connection = Request.Cookies["Company"].Value;
string usernam = Request.Cookies["LoggedUserName"].Value;
BusinessLogic bl = new BusinessLogic(sDataSource);
if (bl.CheckUserHaveAdd(usernam, "JOBENT"))
{
lnkBtnAdd.Enabled = false;
lnkBtnAdd.ToolTip = "You are not allowed to make Add New ";
}
else
{
lnkBtnAdd.Enabled = true;
lnkBtnAdd.ToolTip = "Click to Add New ";
}
}
string dbfileName = sDataSource.Remove(0, sDataSource.LastIndexOf(@"App_Data\") + 9);
dbfileName = dbfileName.Remove(dbfileName.LastIndexOf(";Persist Security Info"));
BusinessLogic objChk = new BusinessLogic();
if (objChk.CheckForOffline(Server.MapPath("Offline\\" + dbfileName + ".offline")))
{
lnkBtnAdd.Visible = false;
gvJob.Columns[6].Visible = false;
gvJob.Columns[7].Visible = false;
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
