private Boolean isValid()
{
hid_FileId.Value = "%";
hid_SupplierId.Value = "%";
if (dd_FileNo.SelectedValue != "0")
{
hid_FileId.Value = dd_FileNo.SelectedValue.ToString() + "X%";
}
if (dd_Supplier.SelectedValue != "0")
{
hid_SupplierId.Value = dd_Supplier.SelectedValue.ToString() + "X%";
}
CommonFunctions commonFunctions = new CommonFunctions();
CommonFunctions.Date_Validation dv = new CommonFunctions.Date_Validation();
if (dv.date_Validate(txt_fromDate.Text) == false)
{
lbl_msg.Visible = true;
lbl_msg.Text = "From Date is Invalid!";
return(false);
}
if (dv.date_Validate(txt_toDate.Text) == false)
{
lbl_msg.Visible = true;
lbl_msg.Text = "To Date is Invalid!";
return(false);
}
return(true);
}
protected void gdv_commonForm_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
CommonFunctions.Date_Validation dateValidation = new CommonFunctions.Date_Validation();
List <string> s_visible = new List <string>(4);
s_visible = (List <string>)ViewState[ViewStateKeys.S_visible];
hidIsInsertMode.Value = "False";
btn_save.Text = "Update";
gdv_commonForm.EnableModelValidation = false;
int i_ind = 1;
if (s_visible[0] == "Y")
{
txt_1stColumn.Text = HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[i_ind].Text);
i_ind += 1;
}
if (s_visible[1] == "Y")
{
txt_2stColumn.Text = HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[i_ind].Text);
i_ind += 1;
}
if (s_visible[2] == "Y")
{
txt_code.Text = HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[i_ind].Text);
i_ind += 1;
}
if (s_visible[3] == "Y")
{
txt_serialNo.Text = HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[i_ind].Text);
i_ind += 1;
}
if (s_visible[4] == "Y")
{
if (HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[i_ind].Text.Trim().ToString()) == "Y")
{
chk_active.Checked = true;
}
else
{
chk_active.Checked = false;
}
i_ind += 1;
}
Session[GlobalVariables.g_s_insertMode] = "1";
}
catch
{
}
}
public void Logout()
{
Connection connection = new Connection();
CommonFunctions.Date_Validation date_validation = new CommonFunctions.Date_Validation();
string s_upadateLogbook = string.Empty;
s_upadateLogbook = Procedures.Common.Proc_Web_Update_UserLogBook
+ "'"
+ Session[GlobalVariables.g_s_userLogBookAutoId].ToString()
+ "','"
+ DateTime.Now.ToString(new CultureInfo("en-US"))
+ "'";
connection.connection_DB(s_upadateLogbook, 1, false, true, true);
Session.RemoveAll();
Response.Redirect(GlobalVariables.g_s_URL_loginPage);
}
private Boolean isValid()
{
CommonFunctions commonFunctions = new CommonFunctions();
CommonFunctions.Date_Validation dv = new CommonFunctions.Date_Validation();
hid_FileId.Value = "0";
if (dd_File.SelectedValue == "0")
{
lbl_msg.Visible = true;
lbl_msg.Text = "File No Blank!";
return(false);
}
else
{
hid_FileId.Value = dd_File.SelectedValue.ToString();
}
return(true);
}
protected void btn_save_Click(object sender, EventArgs e)
{
List <string> s_columnName = new List <string>(4);
s_columnName = (List <string>)ViewState[ViewStateKeys.S_columnName];
List <string> l_access_status = new List <string>(4);
l_access_status = (List <string>)ViewState[ViewStateKeys.V_l_access_status];
CommonFunctions.Date_Validation dataValidation = new CommonFunctions.Date_Validation();
Connection connection = new Connection();
if (b_biult_mustValidation() == false)
{
return;
}
if (s_biult_NumericValidation() == false)
{
return;
}
Session[GlobalVariables.g_s_TableName] = Request.QueryString["tableName"];
try
{
string s_checkField_forDuplicateValue = string.Empty;
s_checkField_forDuplicateValue = s_columnName[0];
string s_activeValue = string.Empty;
if (chk_active.Checked == true)
{
s_activeValue = "Y";
}
else
{
s_activeValue = "N";
}
if (Convert.ToString(Session[GlobalVariables.g_s_insertMode]) == "1" && l_access_status[1] == "Y")
{
Session[GlobalVariables.g_s_ColumnName] = s_biult_ColumnName();
Session[GlobalVariables.g_s_Parameter] = s_biult_Parameter()
+ s_activeValue + "Ã"
+ txt_1stColumn.Text.Trim().ToString().Replace(GlobalVariables.g_s_stringToReplace, GlobalVariables.g_s_stringByReplace) + "Ã";
Session[GlobalVariables.g_s_DuplicateChecking] = "(" + s_biult_DuplicateChecking()
+ ") AND " + "autoId"
+ "<>" + "''" + gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[0].Text + "''";
string sql_Update = Procedures.Common.Proc_Insert_Update_Select_Independent_Tables5
+ " '"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_TableName].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_ColumnName].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_Parameter].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_DuplicateChecking].ToString())
+ "','"
+ HttpUtility.HtmlDecode(gdv_commonForm.Rows[gdv_commonForm.SelectedIndex].Cells[0].Text)
+ "','U','R',''";
Session[GlobalVariables.g_s_procedureReturnType] = connection.connection_DB(sql_Update, 1, true, true, true);
if (Session[GlobalVariables.g_s_procedureReturnType].ToString() != string.Empty && Session[GlobalVariables.g_s_procedureReturnType].ToString() != "D")
{
v_loadGridView();
//insertMode();
btn_refresh_Click(new object(), new EventArgs());
lblMsg.Text = GlobalVariables.g_s_updateOperationSuccessfull;
}
else if (Session[GlobalVariables.g_s_procedureReturnType].ToString() == "D")
{
lblMsg.Text = GlobalVariables.g_s_duplicateCheckWarningMessage;
}
else
{
lblMsg.Text = GlobalVariables.g_s_updateOperationFailed;
}
}
else
{
if (Convert.ToString(Session[GlobalVariables.g_s_insertMode]) == "1" && l_access_status[1] == "N")
{
lblMsg.Text = string.Empty;
lblMsg.Visible = true;
lblMsg.Text = GlobalVariables.g_s_updateSecurityMessage;
}
if (b_checkAttributeRatings())
{
string sql_save = string.Empty;
if (Convert.ToString(Session[GlobalVariables.g_s_insertMode]) == "0" && l_access_status[0] == "Y")
{
if (Session[GlobalVariables.g_s_TableName].ToString() == TableColumnName.T_Web_PerformanceTabDescription.TableName)
{
lblMsg.Text = "Please select from grid";
}
else
{
Session[GlobalVariables.g_s_ColumnName] = "";
Session[GlobalVariables.g_s_Parameter] = "" + Session[GlobalVariables.g_s_autoId].ToString() + "Ã"
+ s_biult_Parameter()
+ txt_1stColumn.Text.Trim().ToString().Replace(GlobalVariables.g_s_stringToReplace, GlobalVariables.g_s_stringByReplace) + "Ã"
+ GlobalVariables.g_s_referenceId + "Ã"
+ Session[GlobalVariables.g_s_CompanyAutoId].ToString() + "Ã"
+ GlobalVariables.g_s_No + "Ã"
+ GlobalVariables.g_s_No + "Ã"
+ dataValidation.date_Format_Back_End(dataValidation.date_Format_Front_End(DateTime.Today)) + "Ã"
+ Session[GlobalVariables.g_s_userLogBookAutoId].ToString();
Session[GlobalVariables.g_s_DuplicateChecking] = "" + s_biult_DuplicateChecking();
sql_save = Procedures.Common.Proc_Insert_Update_Select_Independent_Tables5
+ " '"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_TableName].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_ColumnName].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_Parameter].ToString())
+ "','"
+ HttpUtility.HtmlDecode(Session[GlobalVariables.g_s_DuplicateChecking].ToString())
+ "','','I','R',''";
Session[GlobalVariables.g_s_procedureReturnType] = connection.connection_DB(sql_save, 1, true, true, true);
if (Session[GlobalVariables.g_s_procedureReturnType].ToString() != string.Empty && Session[GlobalVariables.g_s_procedureReturnType].ToString() != "D")
{
v_loadGridView();
insertMode();
lblMsg.Text = GlobalVariables.g_s_insertOperationSuccessfull;
}
else if (Session[GlobalVariables.g_s_procedureReturnType].ToString() == "D")
{
lblMsg.Text = GlobalVariables.g_s_duplicateCheckWarningMessage;
}
else
{
lblMsg.Text = GlobalVariables.g_s_insertOperationFailed;
}
}
if (Convert.ToString(Session[GlobalVariables.g_s_insertMode]) == "0" && l_access_status[0] == "N")
{
lblMsg.Text = string.Empty;
lblMsg.Visible = true;
lblMsg.Text = GlobalVariables.g_s_insertSecurityMessage;
}
}
}
else
{
lblMsg.Text = GlobalVariables.g_s_attributeRatingCheck;
}
}
}
catch (Exception)
{
}
}
private Boolean isValid()
{
Connection conn = new Connection();
CommonFunctions commonFunctions = new CommonFunctions();
string s_FileIdNeeded = string.Empty, returnValue = string.Empty;
CommonFunctions.Date_Validation dv = new CommonFunctions.Date_Validation();
if (dv.date_Validate(txtIssueDate.Text) == false)
{
lblMsg.Visible = true;
lblMsg.Text = "BTB Issue Date Invalid!";
return(false);
}
if (dd_Supplier.SelectedValue == "0")
{
lblMsg.Visible = true;
lblMsg.Text = "Supplier Can Not Blank!";
return(false);
}
if (dd_POSupplier.SelectedValue == "0")
{
lblMsg.Visible = true;
lblMsg.Text = "Supplier(Purchase From) Can Not Blank!";
return(false);
}
//if (txt_BTBNo.Text == "")
//{
// lblsubmsg.Visible = true;
// lblsubmsg.Text = "BTB No Can Not Blank!";
// return false;
//}
if (dd_Currency.SelectedValue == "0")
{
lblMsg.Visible = true;
lblMsg.Text = "Currency Can Not Blank!";
return(false);
}
if (hid_Rownumber.Value == "0")
{
lblMsg.Visible = true;
lblMsg.Text = "PI Grid Can Not Blank!";
return(false);
}
hid_File_Id.Value = "0";
if (dd_FileNo.SelectedValue != "0")
{
s_FileIdNeeded = "SELECT File_Ref_Id FROM TBL_Export_LC Where Export_LC_Id='" + dd_FileNo.SelectedValue + "'";
returnValue = conn.connection_DB(s_FileIdNeeded, 0, false, false, false);
if (returnValue != GlobalVariables.g_s_connectionErrorReturnValue)
{
if (conn.ResultsDataSet.Tables[0] != null)
{
foreach (DataRow drow in conn.ResultsDataSet.Tables[0].Rows)
{
hid_File_Id.Value = drow["File_Ref_Id"].ToString();
}
}
}
}
return(true);
}
