protected void btnEnter_Click(object sender, EventArgs e) { model = new DealerModel(); model.Name = txtName.Text; model.Surname = txtSurname.Text; model.Landline = txtLandline.Text; model.CellphoneNumber = txtCellNumber.Text; model.Email = txtEmail.Text; model.DealershipName = ddlDealerships.SelectedItem.Text;//txtDealershipName.Text; model.DealerType = ddlDealerType.Text; model.Status = ddlStatus.Text; model.Province = ddlProvince.Text; model.Comment = txtComment.Text; DealerDAL.UpdateDealerDetails(model); ShowMessage(ref lblMessage, MessageType.Success, "Dealer Updated Successfully"); lblMessage.Visible = true; }
public ActionResult Index() { DealerDAL dealerDal = new DealerDAL(); return(View(dealerDal.GetDealers())); }
public static int SaveDealerDetails(DealerModel model) { return(DealerDAL.SaveDealerDetails(model)); }
/// <summary> /// 得到用户列表 /// </summary> /// <param name="PageIndex"></param> /// <param name="PageNum"></param> /// <param name="where"></param> /// <param name="Count"></param> /// <returns></returns> public List <AdminModel> GetAdminList(int PageIndex, int PageNum, string where, out int Count) { List <AdminModel> olist = new List <AdminModel>(); Count = 0; SqlConnection sqlConnection = new SqlConnection(Config.ConnectionString); SqlCommand sqlcommand = new SqlCommand("sp_AdminList", sqlConnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter _PageIndex = new SqlParameter("@PageIndex", PageIndex); _PageIndex.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_PageIndex); SqlParameter _PageNum = new SqlParameter("@PageNum", PageNum); _PageNum.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_PageNum); SqlParameter _where = new SqlParameter("@where", where); _where.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_where); SqlParameter _Count = new SqlParameter("@Count", SqlDbType.Int); _Count.Direction = ParameterDirection.Output; sqlcommand.Parameters.Add(_Count); try { sqlConnection.Open(); using (IDataReader idr = sqlcommand.ExecuteReader()) { DealerDAL dd = new DealerDAL(); StoreDAL sd = new StoreDAL(); PermissionsDAL pDal = new PermissionsDAL(); while (idr.Read()) { AdminModel oCModel = new AdminModel(); if (idr["AdminId"] != DBNull.Value) { oCModel.AdminId = (int)idr["AdminId"]; } if (idr["AdminName"] != DBNull.Value) { oCModel.AdminName = (string)idr["AdminName"]; } if (idr["AdminPassword"] != DBNull.Value) { oCModel.AdminPassword = (string)idr["AdminPassword"]; } if (idr["Type"] != DBNull.Value) { oCModel.Type = (AdminType)idr["Type"]; } if (idr["RoleId"] != DBNull.Value) { oCModel.RoleId = (int)idr["RoleId"]; } if (idr["Status"] != DBNull.Value) { oCModel.Status = (bool)idr["Status"]; } if (idr["CreateTime"] != DBNull.Value) { oCModel.CreateTime = (DateTime)idr["CreateTime"]; } if (idr["CreatorId"] != DBNull.Value) { oCModel.CreatorId = (int)idr["CreatorId"]; } int Totoal = 0; List <DealerModel> dModel = dd.GetDealerModelList(1, 1, "DealerInfo.AdminId=" + oCModel.AdminId, out Totoal); if (dModel != null & dModel.Count > 0) { oCModel.Dealer = dModel[0]; } List <StoreModel> oSMoel = sd.GetStoreModelList(1, 1, "StoreInfo.AdminId=" + oCModel.AdminId, out Totoal); if (oSMoel != null & oSMoel.Count > 0) { oCModel.Store = oSMoel[0]; } RoleModel role = new RoleModel(); if (idr["RoleId"] != DBNull.Value) { role.RoleId = (int)idr["RoleId"]; } if (idr["RoleId"] != DBNull.Value) { role.RoleName = (string)idr["RoleName"]; } if (idr["RoleId"] != DBNull.Value) { role.Permissions = pDal.GetRoleModulePermission(role.RoleId); } oCModel.Role = role; olist.Add(oCModel); } } Count = int.Parse(_Count.Value.ToString()); } catch (Exception ex) { throw ex; } finally { sqlConnection.Close(); } return(olist); }
public DealerBLL() { dd = new DealerDAL(); }