/// <summary> /// Add new customer line /// </summary> /// <param name="customerId"></param> /// <param name="lineId"></param> private int AddCustomerLine(int customerId, int lineId) { CustomerLineVo prWDefInVo = new CustomerLineVo { CustomerId = customerId, LineId = lineId, //RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), RegistrationUserCode = UserData.GetUserData().UserCode, FactoryCode = UserData.GetUserData().FactoryCode }; CustomerLineVo outVo = null; try { outVo = (CustomerLineVo)base.InvokeCbm(new AddCustomerLineMasterMntCbm(), prWDefInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); } if (outVo != null & outVo.AffectedCount > 0) { return(outVo.AffectedCount); } return(0); }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind() { Customer_dgv.DataSource = null; CustomerLineVo outVo = null; CustomerLineVo inVo = new CustomerLineVo(); inVo.CustomerId = Convert.ToInt32(CustomerLine_cmb.SelectedValue); inVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue); try { outVo = (CustomerLineVo)DefaultCbmInvoker.Invoke(new GetCustomerLineCbm(), inVo); Customer_dgv.AutoGenerateColumns = false; Customer_dgv.DataSource = outVo.customerLineListVo; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } BindingSource CustomerLineBindingSource = new BindingSource(outVo.customerLineListVo, null); if (CustomerLineBindingSource.Count == 0) { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } Customer_dgv.ClearSelection(); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerLineVo inVo = (CustomerLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_customer_line"); sqlQuery.Append(" Where "); sqlQuery.Append(" line_id = :lineid "); sqlQuery.Append(" and factory_cd = :factorycode "); if (inVo.CustomerId > 0) { sqlQuery.Append(" and customer_id = :customerid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); if (inVo.CustomerId > 0) { sqlParameter.AddParameterInteger("customerid", inVo.CustomerId); } CustomerLineVo outVo = new CustomerLineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerLineVo inVo = (CustomerLineVo)arg; CustomerLineVo outVo = new CustomerLineVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_customer_line"); sqlQuery.Append(" ( "); sqlQuery.Append(" customer_id, "); sqlQuery.Append(" line_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :customerid ,"); sqlQuery.Append(" :lineid ,"); sqlQuery.Append(" :registrationusercd ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); foreach (CustomerLineVo curVo in inVo.customerLineListVo) { //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("customerid", curVo.CustomerId); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterString("registrationusercd", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); outVo.AffectedCount += sqlCommandAdapter.ExecuteNonQuery(sqlParameter); } return(outVo); }
/// <summary> /// Delete customer line /// </summary> /// <param name="customerId"></param> /// <param name="lineId"></param> private int DeleteCustomerLine(int customerId, int lineId) { CustomerLineVo delInVo = new CustomerLineVo { CustomerId = customerId, LineId = lineId }; CustomerLineVo delOutVo = null; try { delOutVo = (CustomerLineVo)base.InvokeCbm(new DeleteCustomerLineMasterMntCbm(), delInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); } if (delOutVo != null && delOutVo.AffectedCount > 0) { return(delOutVo.AffectedCount); } return(0); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerLineVo inVo = (CustomerLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select"); sqlQuery.Append(" cl.customer_line_id,"); sqlQuery.Append(" cl.customer_id,"); sqlQuery.Append(" cl.line_id,"); sqlQuery.Append(" c.customer_name,"); sqlQuery.Append(" l.line_name"); sqlQuery.Append(" from m_customer_line cl"); sqlQuery.Append(" inner join m_customer c on cl.customer_id = c.customer_id"); sqlQuery.Append(" inner join m_line l on cl.line_id = l.line_id"); sqlQuery.Append(" where cl.factory_cd = :faccd "); if (inVo.LineId > 0) { sqlQuery.Append(" and cl.line_id = :lineid"); } if (inVo.CustomerId > 0) { sqlQuery.Append(" and cl.customer_id = :customerid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.LineId > 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } if (inVo.CustomerId > 0) { sqlParameter.AddParameterInteger("customerid", inVo.CustomerId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); CustomerLineVo outVo = new CustomerLineVo(); while (dataReader.Read()) { CustomerLineVo currOutVo = new CustomerLineVo { CustomerLineId = Convert.ToInt32(dataReader["customer_line_id"]), LineId = Convert.ToInt32(dataReader["line_id"]), CustomerId = Convert.ToInt32(dataReader["customer_id"]), CustomerName = dataReader["customer_name"].ToString(), LineName = dataReader["line_name"].ToString() }; outVo.customerLineListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerLineVo inVo = (CustomerLineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" SELECT "); sqlQuery.Append(" cl.customer_line_id, "); sqlQuery.Append(" c.customer_cd, "); sqlQuery.Append(" c.customer_name, "); sqlQuery.Append(" l.line_cd, "); sqlQuery.Append(" l.line_name "); sqlQuery.Append(" FROM "); sqlQuery.Append(" m_customer_line cl "); sqlQuery.Append(" inner join m_customer c on c.customer_id = cl.customer_id "); sqlQuery.Append(" inner join m_line l on l.line_id = cl.line_id "); sqlQuery.Append(" WHERE "); sqlQuery.Append(" c.factory_cd = :factorycode "); if (inVo.CustomerId > 0) { sqlQuery.Append(" AND c.customer_id = :customerid "); } if (inVo.LineId > 0) { sqlQuery.Append(" AND l.line_id = :lineid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (!string.IsNullOrEmpty(inVo.FactoryCode)) { sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); } else { sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); } if (inVo.CustomerId > 0) { sqlParameter.AddParameterInteger("customerid", inVo.CustomerId); } if (inVo.LineId > 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); CustomerLineVo outVo = new CustomerLineVo(); while (dataReader.Read()) { CustomerLineVo currOutVo = new CustomerLineVo(); currOutVo.CustomerLineId = ConvertDBNull <int>(dataReader, "customer_line_id"); // currOutVo.CustomerCd = ConvertDBNull<string>(dataReader, "customer_cd"); currOutVo.CustomerName = ConvertDBNull <string>(dataReader, "customer_name"); // currOutVo.LineCd = ConvertDBNull<string>(dataReader, "line_cd"); currOutVo.LineName = ConvertDBNull <string>(dataReader, "line_name"); outVo.customerLineListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// Binds tree view /// </summary> /// <param name="prcWrkList"></param> private void PopulateTreeView(List <CustomerVo> prcWrkList) { LineVo linOutVo = new LineVo(); try { linOutVo = (LineVo)base.InvokeCbm(new GetLineMasterMntCbm(), linInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } CustomerLineDetails_tv.Nodes.Clear(); TreeNode[] headerNode = new TreeNode[prcWrkList.Count]; int i = 0; foreach (CustomerVo prcW in prcWrkList) { TreeNode child = new TreeNode { Text = prcW.CustomerCode + " " + prcW.CustomerName, Tag = prcW.CustomerId }; headerNode[i] = child; int childNodes = linOutVo.LineListVo.Count; TreeNode[] rootNodes = new TreeNode[childNodes]; int node = 0; CustomerLineVo inVo = new CustomerLineVo(); inVo.CustomerId = Convert.ToInt32(Customer_cmb.SelectedValue); CustomerLineVo prcDefRsnOutVo = new CustomerLineVo(); try { prcDefRsnOutVo = (CustomerLineVo)base.InvokeCbm(new GetCustomerLineMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (LineVo dfrVo in linOutVo.LineListVo) { TreeNode rootChild = new TreeNode { Text = dfrVo.LineCode + " " + dfrVo.LineName, Tag = dfrVo.LineId }; List <CustomerLineVo> prcDefRsnList = prcDefRsnOutVo.customerLineListVo.Where(t => t.CustomerId == Convert.ToInt32(child.Tag)).ToList(); foreach (CustomerLineVo prDfRsnVo in prcDefRsnList) { if (prDfRsnVo.LineId == Convert.ToInt32(rootChild.Tag)) { rootChild.Checked = true; } } rootNodes[node] = rootChild; headerNode[i].Nodes.Add(rootNodes[node]); node += 1; } CustomerLineDetails_tv.Nodes.Add(headerNode[i]); i += 1; } if (CustomerLineDetails_tv.Nodes.Count > 0) { Update_btn.Enabled = true; } }
/// <summary> /// updates customer line /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Update_btn_Click(object sender, EventArgs e) { if (CustomerLineDetails_tv.Nodes.Count == 0) { return; } int prcDefCount; int prcWrkId; int defRsnId; int resultcnt = 0; Cursor.Current = Cursors.WaitCursor; TreeNodeCollection nodes = CustomerLineDetails_tv.Nodes; CustomerLineVo prcDefCheckVo = new CustomerLineVo(); try { prcDefCheckVo = (CustomerLineVo)base.InvokeCbm(new GetCustomerLineMasterMntCbm(), new CustomerLineVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); Logger.Error(exception.GetMessageData()); return; } foreach (TreeNode tn in nodes) { foreach (TreeNode child in tn.Nodes) { //Check customer line is already added. prcWrkId = Convert.ToInt32(tn.Tag.ToString()); defRsnId = Convert.ToInt32(child.Tag.ToString()); prcDefCount = prcDefCheckVo.customerLineListVo.Where(t => t.CustomerId == prcWrkId && t.LineId == defRsnId).Count(); if (child.Checked) { if (prcDefCount == 0) { resultcnt += AddCustomerLine(prcWrkId, defRsnId); } } else { if (prcDefCount == 1) { resultcnt += DeleteCustomerLine(prcWrkId, defRsnId); } } } } if (resultcnt == 0) { return; } Cursor.Current = Cursors.Default; messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); Logger.Info(messageData); popUpMessage.Information(messageData, Text); }