public frmRegisterStatus() { InitializeComponent(); m_oStatus = new Vendor.BusinessLayer.StatusBL(); m_oRegister = new Vendor.BusinessLayer.RegisterBL(); m_oRegUpdate = new Vendor.BusinessLayer.RegUpdateBL(); }
public frmRegTrans() { InitializeComponent(); m_oRegister = new Vendor.BusinessLayer.RegisterBL(); m_oRegUpdate = new Vendor.BusinessLayer.RegUpdateBL(); oVType = new BsfGlobal.VoucherType(); }
public void UpdateGradeTrans(Vendor.BusinessLayer.RegisterBL argRegister) { SqlConnection conn; conn = new SqlConnection(); conn = BsfGlobal.OpenVendorAnalDB(); SqlTransaction tran = conn.BeginTransaction(); try { SqlCommand Command = new SqlCommand("Update_GradeTrans", conn, tran); Command.CommandType = CommandType.StoredProcedure; Command.Parameters.Clear(); Command.Parameters.AddWithValue("@VendorId", argRegister.VendorId); Command.Parameters.AddWithValue("@SGradeId", argRegister.SGradeId); Command.Parameters.AddWithValue("@CGradeId", argRegister.CGradeId); Command.Parameters.AddWithValue("@HGradeId", argRegister.HGradeId); Command.ExecuteNonQuery(); tran.Commit(); } catch { tran.Rollback(); } finally { conn.Close(); } }
public void InsertAssessment(Vendor.BusinessLayer.RegisterBL argRegister) { SqlConnection conn; conn = new SqlConnection(); conn = BsfGlobal.OpenVendorAnalDB(); SqlTransaction tran = conn.BeginTransaction(); try { SqlCommand Command = new SqlCommand("Insert_VendorAssesment", conn, tran); Command.CommandType = CommandType.StoredProcedure; Command.Parameters.Clear(); Command.Parameters.AddWithValue("@VendorId", argRegister.VendorId); Command.Parameters.AddWithValue("@SupplyMaxPoint", argRegister.SupplyMaxPoint); Command.Parameters.AddWithValue("@SupplyPoints", argRegister.SupplyPoints); Command.Parameters.AddWithValue("@ContractMaxPoint", argRegister.ContractMaxPoint); Command.Parameters.AddWithValue("@ContractPoints", argRegister.ContractPoints); Command.Parameters.AddWithValue("@ServiceMaxPoint", argRegister.ServiceMaxPoint); Command.Parameters.AddWithValue("@ServicePoints", argRegister.ServicePoints); Command.ExecuteNonQuery(); tran.Commit(); } catch { tran.Rollback(); } finally { conn.Close(); } }
public void InsertRegTrans(Vendor.BusinessLayer.RegisterBL argRegister, int argTypeId) { SqlConnection conn; conn = new SqlConnection(); conn = BsfGlobal.OpenVendorAnalDB(); SqlTransaction tran = conn.BeginTransaction(); try { SqlCommand Command = new SqlCommand("Insert_RegTrans", conn, tran); Command.CommandType = CommandType.StoredProcedure; Command.Parameters.Clear(); Command.Parameters.AddWithValue("@VendorId", argRegister.VendorId); Command.Parameters.AddWithValue("@RegId", argRegister.RegisterId); Command.Parameters.AddWithValue("@RDate", argRegister.RegDate); Command.Parameters.AddWithValue("@RefNo ", argRegister.RegNo); Command.Parameters.AddWithValue("@StatusType ", argRegister.StatusType); Command.Parameters.AddWithValue("@Supply", argRegister.Supply); Command.Parameters.AddWithValue("@Contract", argRegister.Contract); Command.Parameters.AddWithValue("@Service", argRegister.Service); Command.Parameters.AddWithValue("@SGradeId", argRegister.SGradeId); Command.Parameters.AddWithValue("@CGradeId", argRegister.CGradeId); Command.Parameters.AddWithValue("@HGradeId", argRegister.HGradeId); Command.Parameters.AddWithValue("@SFDate", argRegister.SFDate); Command.Parameters.AddWithValue("@STDate", argRegister.STDate); Command.Parameters.AddWithValue("@CFDate", argRegister.CFDate); Command.Parameters.AddWithValue("@CTDate", argRegister.CTDate); Command.Parameters.AddWithValue("@HFDate", argRegister.HFDate); Command.Parameters.AddWithValue("@HTDate", argRegister.HTDate); Command.Parameters.AddWithValue("@SLifeTime", argRegister.SLife); Command.Parameters.AddWithValue("@CLifeTime", argRegister.CLife); Command.Parameters.AddWithValue("@HLifeTime", argRegister.HLife); Command.Parameters.AddWithValue("@Remarks", argRegister.Remarks); Command.ExecuteNonQuery(); //Command = new SqlCommand("Update_MaxNo", conn, tran); //Command.CommandType = CommandType.StoredProcedure; //Command.Parameters.Clear(); //Command.Parameters.AddWithValue("@TypeId", argTypeId); //Command.ExecuteNonQuery(); tran.Commit(); } catch { tran.Rollback(); } finally { conn.Close(); } }
public void UpdateRegTrans(Vendor.BusinessLayer.RegisterBL argRegister) { m_oRegister.UpdateRegTrans(argRegister); }
public void InsertRegTrans(Vendor.BusinessLayer.RegisterBL argRegister, int argTypeId) { m_oRegister.InsertRegTrans(argRegister, argTypeId); }
public void UpdateRegistration(Vendor.BusinessLayer.RegisterBL argRegister) { m_oRegister.UpdateRegistration(argRegister); }
public void InsertRegistration(Vendor.BusinessLayer.RegisterBL argRegister) { m_oRegister.InsertRegistration(argRegister); }
public void InsertAssessment(Vendor.BusinessLayer.RegisterBL argRegister) { m_oRegister.InsertAssessment(argRegister); }
public void UpdateRegistration(int argVendorId) { Vendor.BusinessLayer.RegUpdateBL oRegUpdate; Vendor.BusinessLayer.RegisterBL oRegister; oRegUpdate = new Vendor.BusinessLayer.RegUpdateBL(); oRegister = new Vendor.BusinessLayer.RegisterBL(); DataSet ds = new DataSet(); ds = oRegister.GetRegUpdateDetails(argVendorId); DataTable dtM = new DataTable(); DataTable dtS = new DataTable(); DataTable dtC = new DataTable(); DataTable dtH = new DataTable(); dtM = ds.Tables[0]; dtS = ds.Tables[1]; dtC = ds.Tables[2]; dtH = ds.Tables[3]; if (dtM.Rows.Count > 0) { oRegUpdate.RegisterId = Convert.ToInt32(dtM.Rows[0]["RegisterId"].ToString()); oRegUpdate.VendorId = argVendorId; oRegUpdate.Supply = Convert.ToBoolean(dtM.Rows[0]["Supply"].ToString()); oRegUpdate.Contract = Convert.ToBoolean(dtM.Rows[0]["Contract"].ToString()); oRegUpdate.Service = Convert.ToBoolean(dtM.Rows[0]["Contract"].ToString()); oRegUpdate.STDate = Convert.ToDateTime(dtM.Rows[0]["STDate"].ToString()); oRegUpdate.CTDate = Convert.ToDateTime(dtM.Rows[0]["HTDate"].ToString()); oRegUpdate.HTDate = Convert.ToDateTime(dtM.Rows[0]["HTDate"].ToString()); oRegUpdate.SLife = Convert.ToBoolean(dtM.Rows[0]["SLifeTime"].ToString()); oRegUpdate.CLife = Convert.ToBoolean(dtM.Rows[0]["CLifeTime"].ToString()); oRegUpdate.HLife = Convert.ToBoolean(dtM.Rows[0]["HLifeTime"].ToString()); oRegUpdate.SGradeId = Convert.ToInt32(dtM.Rows[0]["SGradeId"].ToString()); oRegUpdate.CGradeId = Convert.ToInt32(dtM.Rows[0]["SGradeId"].ToString()); oRegUpdate.HGradeId = Convert.ToInt32(dtM.Rows[0]["SGradeId"].ToString()); } if (dtS.Rows.Count > 0) { if (dtS.Rows[0]["StatusType"].ToString() == "R") { oRegUpdate.Supply = true; oRegUpdate.STDate = Convert.ToDateTime(dtS.Rows[0]["STDate"].ToString()); oRegUpdate.SLife = Convert.ToBoolean(dtS.Rows[0]["SLifeTime"].ToString()); oRegUpdate.SGradeId = Convert.ToInt32(dtS.Rows[0]["SGradeId"].ToString()); } else if (dtS.Rows[0]["StatusType"].ToString() == "S") { oRegUpdate.SSuspend = true; oRegUpdate.STDate = Convert.ToDateTime(dtS.Rows[0]["STDate"].ToString()); } else if (dtS.Rows[0]["StatusType"].ToString() == "B") { oRegUpdate.SBlackList = true; } } if (dtC.Rows.Count > 0) { if (dtC.Rows[0]["StatusType"].ToString() == "R") { oRegUpdate.Contract = true; oRegUpdate.CTDate = Convert.ToDateTime(dtC.Rows[0]["CTDate"].ToString()); oRegUpdate.CLife = Convert.ToBoolean(dtC.Rows[0]["CLifeTime"].ToString()); oRegUpdate.CGradeId = Convert.ToInt32(dtC.Rows[0]["CGradeId"].ToString()); } else if (dtC.Rows[0]["StatusType"].ToString() == "S") { oRegUpdate.CSuspend = true; oRegUpdate.CTDate = Convert.ToDateTime(dtC.Rows[0]["CTDate"].ToString()); } else if (dtC.Rows[0]["StatusType"].ToString() == "B") { oRegUpdate.CBlackList = true; } } if (dtH.Rows.Count > 0) { if (dtH.Rows[0]["StatusType"].ToString() == "R") { oRegUpdate.Service = true; //oRegUpdate.HTDate = Convert.ToDateTime(dtH.Rows[0]["HTDate"].ToString()); //oRegUpdate.HLife = Convert.ToBoolean(dtH.Rows[0]["HLifeTime"].ToString()); //oRegUpdate.HGradeId = Convert.ToInt32(dtH.Rows[0]["HGradeId"].ToString()); } else if (dtH.Rows[0]["StatusType"].ToString() == "S") { oRegUpdate.HSuspend = true; //oRegUpdate.HTDate = Convert.ToDateTime(dtH.Rows[0]["HTDate"].ToString()); } else if (dtH.Rows[0]["StatusType"].ToString() == "B") { oRegUpdate.HBlackList = true; } } oRegister.InsertRegTransLatest(oRegUpdate); if (clsStatic.g_bTypeSelection == true) { bool bSupply = false; bool bContract = false; bool bService = false; if (oRegUpdate.Supply == true) { if (oRegUpdate.SSuspend == true | oRegUpdate.SBlackList == true) { bSupply = false; } else { bSupply = true; } } if (oRegUpdate.Contract == true) { if (oRegUpdate.CSuspend == true | oRegUpdate.CBlackList == true) { bContract = false; } else { bContract = true; } } if (oRegUpdate.Service == true) { if (oRegUpdate.HSuspend == true | oRegUpdate.HBlackList == true) { bService = false; } else { bService = true; } } UpdateVendorType(oRegUpdate.VendorId, bSupply, bContract, bService); } }