protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToDateTime(DateTime.Now.ToShortDateString()) <= Convert.ToDateTime(textBox.Text))
{
string strTableName = (Session["OrderTableName"] == null) ? "SOHeader" : Session["OrderTableName"].ToString();
if (Name.Trim() == "CustReqDt")
{
string strSchDt = customerDetail.GetValues(strTableName, "SchShipDt", HeaderIDColumn + "=" + SOOrderID);
if (Convert.ToDateTime(strSchDt) <= Convert.ToDateTime(textBox.Text))
{
string ColumnValue = "[" + Name + "]='" + textBox.Text + "'";
customerDetail.UpdateHeader(strTableName, ColumnValue + ",ChangeID='" + Session["UserName"].ToString() + "',ChangeDt='" + DateTime.Now.ToShortDateString() + "'", HeaderIDColumn + "=" + SOOrderID);
}
else
{
ScriptManager.RegisterClientScriptBlock(btnUpdate, typeof(Button), "Invalid", "alert('Customer req Date should not be less than Sch Ship Date.');document.getElementById('" + textBox.ClientID + "').value=' ';document.getElementById('" + textBox.ClientID + "').focus();document.getElementById('" + textBox.ClientID + "').select();", true);
}
}
else
{
string ColumnValue = "[" + Name + "]='" + textBox.Text + "'";
customerDetail.UpdateHeader(strTableName, ColumnValue + ",ChangeID='" + Session["UserName"].ToString() + "',ChangeDt='" + DateTime.Now.ToShortDateString() + "'", HeaderIDColumn + "=" + SOOrderID);
// Update the sch ship value in sodetail reqshipdt field
if (Name.Trim() == "SchShipDt")
{
hidPreviousvalue.Value = textBox.Text;
customerDetail.UpdateHeader(Session["DetailTableName"].ToString(), "RqstdShipDt='" + textBox.Text + "',ChangeID='" + Session["UserName"].ToString() + "',ChangeDate='" + DateTime.Now.ToShortDateString() + "'", HeaderIDColumn + "=" + SOOrderID);
OnBubbleClick(e);
}
}
ScriptManager.RegisterClientScriptBlock(btnUpdate, typeof(Button), "nextCtl", "document.getElementById('" + Image1.ClientID + "').focus();document.getElementById('" + Image1.ClientID + "').select();", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(btnUpdate, typeof(Button), "Invalid", "alert('Invalid Date');document.getElementById('" + textBox.ClientID + "').focus();document.getElementById('" + textBox.ClientID + "').select();", true);
}
}
catch (Exception ex) { }
}
