public bool UpdateGeneralSettings(mdlGeneralSettings obj_mdlGeneralSettings)
{
return obj_dalGeneralSettings.UpdateGeneralSettings(obj_mdlGeneralSettings);
}
public bool SaveGeneralSettings(mdlGeneralSettings obj_mdlGeneralSettings)
{
return obj_dalGeneralSettings.SaveGeneralSettings(obj_mdlGeneralSettings);
}
public bool UpdateGeneralSettings(mdlGeneralSettings obj_mdlGeneralSettings)
{
bool Update = false;
try
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
byte[] intBytes = BitConverter.GetBytes(0x0);
SqlCommand cmd = new SqlCommand("stp_ERP_SystemInformation_CRUD", con);
cmd.Parameters.Add("@BranchID", SqlDbType.VarChar, 2).Value = obj_mdlGeneralSettings.BranchID;
cmd.Parameters.Add("@BranchName", SqlDbType.VarChar, 40).Value = obj_mdlGeneralSettings.BranchName;
cmd.Parameters.Add("@Address", SqlDbType.VarChar, 100).Value = obj_mdlGeneralSettings.Address;
cmd.Parameters.Add("@Phone", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.Phone;
cmd.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.Fax;
cmd.Parameters.Add("@EMail", SqlDbType.VarChar, 50).Value = obj_mdlGeneralSettings.EMail;
cmd.Parameters.Add("@Website", SqlDbType.VarChar, 50).Value = obj_mdlGeneralSettings.Website;
cmd.Parameters.Add("@WarName", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.WarName;
cmd.Parameters.Add("@PoweredBy", SqlDbType.VarChar, 40).Value = obj_mdlGeneralSettings.PoweredBy;
cmd.Parameters.Add("@Sequence", SqlDbType.Int).Value = obj_mdlGeneralSettings.Sequence;
cmd.Parameters.Add("@NTN_No", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.NTN_No;
cmd.Parameters.Add("@LicNo1", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.License1;
cmd.Parameters.Add("@LicNo2", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.License2;
cmd.Parameters.Add("@LicNo3", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.License3;
cmd.Parameters.Add("@FederalTaxID1", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.FederalTaxID1;
cmd.Parameters.Add("@FederalTaxID2", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.FederalTaxID2;
cmd.Parameters.Add("@ExemptionID", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.ExemptionID;
cmd.Parameters.Add("@TaxDeducation", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.TaxDeduction;
cmd.Parameters.Add("@Currency", SqlDbType.VarChar, 15).Value = obj_mdlGeneralSettings.Currency;
if (obj_mdlGeneralSettings.War_Sign != null)
{
cmd.Parameters.Add("@War_Sign", SqlDbType.Image).Value = obj_mdlGeneralSettings.War_Sign;
}
else
{
cmd.Parameters.Add("@War_Sign", SqlDbType.Image).Value = intBytes;
}
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.AddUser;
cmd.Parameters.Add("@AddComputer", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.LoginComputer;
cmd.Parameters.Add("@LicenseExp1", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.LicenseExpiry1;
cmd.Parameters.Add("@LicenseExp2", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.LicenseExpiry2;
cmd.Parameters.Add("@LicenseExp3", SqlDbType.VarChar, 20).Value = obj_mdlGeneralSettings.LicenseExpiry3;
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 10).Value = "Update";
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
Update = true;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
Update = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return Update;
}
