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) { } }