public static MCustomer MCustomerEmpty(this BoCustomer oBCustomer) { var lObject = LiUtilsLib.bll_GetObjectByName(MGlobalVariables.LNameObjectCustomer); var lMCustomer = new MCustomer { LObject = new MObject { LIdObject = lObject.LIdObject, LNameObject = lObject.LNameObject }, LStatus = new MStatus { LDsEstado = null, LIdStatus = null }, LTypeIdentification = new MTypeIdentification { LIdTypeIdentification = 0, LTypeIdentification = null }, LListTypeIdentification = new List <SelectListItem>(), LListStatus = new List <SelectListItem>(), LNameCustomer = null, LLastNameCustomer = null, LNoIdentification = null, LIdCustomer = 0, LCreationDate = new DateTime(), LModificationDate = new DateTime() }; lMCustomer.LListTypeIdentification = LiTypeIdentification.bll_getListTypeIdentification().MListAllTypeIdentificationWithSelect(true); lMCustomer.LListStatus = LiStatus.Bll_getListStatusByIdObject(lMCustomer.LObject.LIdObject).MListStatusWithSelect(); return(lMCustomer); }
public static MCustomer MCustomerById(this BoCustomer oBCustomer) { var oMCustomer = new MCustomer { LObject = new MObject { LIdObject = oBCustomer.LObject.LIdObject, LNameObject = oBCustomer.LObject.LNameObject }, LStatus = new MStatus { LDsEstado = oBCustomer.LStatus.LDsEstado, LIdStatus = oBCustomer.LStatus.LIdStatus }, LTypeIdentification = new MTypeIdentification { LIdTypeIdentification = oBCustomer.LTypeIdentification.LIdTypeIdentification, LTypeIdentification = oBCustomer.LTypeIdentification.LTypeIdentification }, LListTypeIdentification = new List <SelectListItem>(), LListStatus = new List <SelectListItem>(), LNameCustomer = oBCustomer.LNameCustomer, LLastNameCustomer = oBCustomer.LLastNameCustomer, LNoIdentification = oBCustomer.LNoIdentification, LIdCustomer = oBCustomer.LIdCustomer, LCreationDate = oBCustomer.LCreationDate, LModificationDate = oBCustomer.LModificationDate }; oMCustomer.LListTypeIdentification = LiTypeIdentification.bll_getListTypeIdentification().MListAllTypeIdentification(); oMCustomer.LListStatus = LiStatus.Bll_getListStatusByIdObject(oBCustomer.LObject.LIdObject).MListAllStatus(); return(oMCustomer); }
public string bll_DeleteCustomer(int pIdCustomer) { var oCustomer = new BoCustomer { LIdCustomer = pIdCustomer }; return(this.LiCustomer.Dao_DeleteCustomer(oCustomer)); }
public BoCustomer Dao_getTypeIdentification(int pIdTypeIdentification) { SqlConnection lConex = new SqlConnection(); using (lConex = Dao_SqlConnection(lConex)) { var lCustomer = new BoCustomer(); try { var lCommand = new SqlCommand { CommandText = "spr_GetListAllTypeIdentification", CommandTimeout = 30, CommandType = CommandType.StoredProcedure, Connection = lConex }; lCommand.Parameters.Add(new SqlParameter("IdCustomer", pIdTypeIdentification)); var lReader = lCommand.ExecuteReader(); if (lReader.HasRows) { while (lReader.Read()) { lCustomer.LTypeIdentification = new BoTypeIdentification(); lCustomer.LIdCustomer = Convert.ToInt32(lReader["IdCustomer"].ToString()); lCustomer.LTypeIdentification.LIdTypeIdentification = Convert.ToInt32(lReader["IdTypeIdentification"].ToString()); lCustomer.LNoIdentification = lReader["NoIdentification"].ToString(); lCustomer.LNameCustomer = lReader["NameCustomer"].ToString(); lCustomer.LLastNameCustomer = lReader["LastNameCustomer"].ToString(); lCustomer.LStatus = new BoStatus { LIdStatus = lReader["IdStatus"].ToString() }; lCustomer.LObject = new BoObject { LIdObject = Convert.ToInt32(lReader["IdObject"].ToString()) }; } } Dao_CloseSqlconnection(lConex); return(lCustomer); } catch (Exception e) { lCustomer = new BoCustomer { LException = e.Message, LMessageDao = BoErrors.MsgErrorGetSql }; if (e.InnerException != null) { lCustomer.LInnerException = e.InnerException.ToString(); } Dao_CloseSqlconnection(lConex); return(lCustomer); } } }
public BoCustomer Dao_getCustomerByDocument(string pNoIdentification, int pIdTypeIdentification) { SqlConnection lConex = new SqlConnection(); using (lConex = DaoUtilsLib.Dao_SqlConnection(lConex)) { try { var lCommand = new SqlCommand { CommandText = "spr_GetCustomerByIdentification", CommandTimeout = 30, CommandType = CommandType.StoredProcedure, Connection = lConex }; lCommand.Parameters.Add(new SqlParameter("@NoIdentification", pNoIdentification)); lCommand.Parameters.Add(new SqlParameter("@IdTypeIdentification", pIdTypeIdentification)); var lReader = lCommand.ExecuteReader(); var oCustomer = new BoCustomer(); if (lReader.HasRows) { while (lReader.Read()) { oCustomer.LStatus = new BoStatus(); oCustomer.LObject = new BoObject(); oCustomer.LTypeIdentification = new BoTypeIdentification(); oCustomer.LIdCustomer = Convert.ToInt32(lReader["IdCustomer"].ToString()); oCustomer.LTypeIdentification.LIdTypeIdentification = Convert.ToInt32(lReader["IdTypeIdentification"].ToString()); oCustomer.LNoIdentification = lReader["NoIdentification"].ToString(); oCustomer.LNameCustomer = lReader["NameCustomer"].ToString(); oCustomer.LLastNameCustomer = lReader["LastNameCustomer"].ToString(); oCustomer.LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString()); oCustomer.LModificationDate = Convert.ToDateTime(lReader["ModificationDate"].ToString()); oCustomer.LStatus.LIdStatus = lReader["IdStatus"].ToString(); oCustomer.LObject.LIdObject = Convert.ToInt32(lReader["IdObject"].ToString()); } } DaoUtilsLib.Dao_CloseSqlconnection(lConex); return(oCustomer); } catch (Exception e) { var oCustomer = new BoCustomer { LException = e.Message }; if (e.InnerException != null) { oCustomer.LInnerException = e.InnerException.ToString(); } oCustomer.LMessageDao = BoErrors.MsgErrorGetSql; DaoUtilsLib.Dao_CloseSqlconnection(lConex); return(oCustomer); } } }
public string Dao_UpdateCustomer(BoCustomer pCustomer) { this.LListParams = new List <SqlParameter>(); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString()); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NameCustomer", pCustomer.LNameCustomer); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@LastNameCustomer", pCustomer.LLastNameCustomer); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdTypeIdentification", pCustomer.LTypeIdentification.LIdTypeIdentification.ToString()); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@NoIdentification", pCustomer.LNoIdentification); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.VarChar, "@IdStatus", pCustomer.LStatus.LIdStatus); return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranUpdateCustomer", "spr_UpdateCustomer")); }
public string bll_InsertCustomer(string pNameCustomer, string pLastNameCustomer, string pNoIdentification, int pIdTypeIdentification, int pIdObject, string pIdStatus) { var oCustomer = new BoCustomer { LObject = new BoObject { LIdObject = pIdObject }, LStatus = new BoStatus { LIdStatus = pIdStatus }, LTypeIdentification = new BoTypeIdentification { LIdTypeIdentification = pIdTypeIdentification }, LNameCustomer = pNameCustomer, LLastNameCustomer = pLastNameCustomer, LNoIdentification = pNoIdentification }; return(this.LiCustomer.Dao_InsertCustomer(oCustomer)); }
public string Dao_DeleteCustomer(BoCustomer pCustomer) { this.LListParams = new List <SqlParameter>(); DaoUtilsLib.dao_Addparameters(this.LListParams, SqlDbType.Int, "@IdCustomer", pCustomer.LIdCustomer.ToString()); return(DaoUtilsLib.Dao_executeSqlTransactionWithProcedement(this.LListParams, "LTranDeleteCustomer", "spr_DeleteCustomer")); }
public List <BoCustomer> Dao_getListAllCustomer() { SqlConnection lConex = new SqlConnection(); using (lConex = DaoUtilsLib.Dao_SqlConnection(lConex)) { try { var lCommand = new SqlCommand { CommandText = "spr_GetListAllCustomer", CommandTimeout = 30, CommandType = CommandType.StoredProcedure, Connection = lConex }; var lReader = lCommand.ExecuteReader(); var oListCustomer = new List <BoCustomer>(); if (lReader.HasRows) { while (lReader.Read()) { var oCustomer = new BoCustomer { LStatus = new BoStatus { LIdStatus = lReader["IdStatus"].ToString(), LDsEstado = lReader["DsEstado"].ToString() }, LObject = new BoObject { LIdObject = Convert.ToInt32(lReader["IdObject"].ToString()), LNameObject = lReader["NameObject"].ToString() }, LTypeIdentification = new BoTypeIdentification { LIdTypeIdentification = Convert.ToInt32(lReader["IdTypeIdentification"].ToString()), LTypeIdentification = lReader["TypeIdentification"].ToString() }, LIdCustomer = Convert.ToInt32(lReader["IdCustomer"].ToString()), LNoIdentification = lReader["NoIdentification"].ToString(), LNameCustomer = lReader["NameCustomer"].ToString(), LLastNameCustomer = lReader["LastNameCustomer"].ToString(), LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString() == "" ? new DateTime().ToString(CultureInfo.InvariantCulture) : lReader["CreationDate"].ToString()), LModificationDate = Convert.ToDateTime(lReader["ModificationDate"].ToString() == "" ? new DateTime().ToString(CultureInfo.InvariantCulture) : lReader["ModificationDate"].ToString()) }; oListCustomer.Add(oCustomer); } } DaoUtilsLib.Dao_CloseSqlconnection(lConex); return(oListCustomer); } catch (Exception e) { var oListCustomer = new List <BoCustomer>(); var oCustomer = new BoCustomer { LException = e.Message }; if (e.InnerException != null) { oCustomer.LInnerException = e.InnerException.ToString(); } oCustomer.LMessageDao = BoErrors.MsgErrorGetSql; oListCustomer.Add(oCustomer); DaoUtilsLib.Dao_CloseSqlconnection(lConex); return(oListCustomer); } } }
// GET: Customer/Create public ActionResult Create() { var oBCustomer = new BoCustomer(); return(this.View(oBCustomer.MCustomerEmpty())); }