public int ExecuteThenInsertTrans(Dictionary <String, List <CustomSqlParam> > sqlDirectionary, DataSet model) { using (CommonDal Access = new CommonDal(_dct)) { return(Access.ExecuteThenInsertTrans(sqlDirectionary, model)); } }
/// <summary> /// 批量插入数据 /// </summary> /// <param name="dt"></param> /// <param name="mappingname"></param> /// <param name="OnRowsCopied"></param> public bool BulkInsert(DataSet model) { using (CommonDal Access = new CommonDal(_dct)) { return(Access.BulkInsert(model)); } }
public ActionResult Index(int?page) { //Pager pager = new Pager(); //pager.table = "Product"; //pager.strwhere = "1=1"; //pager.PageSize = 12; //pager.PageNo = page ?? 1; //pager.FieldKey = "Id"; //pager.FiledOrder = "Id desc"; //pager = CommonDal.GetPager(pager); //IList<Product> dataList = DataConvertHelper<Product>.ConvertToModel(pager.EntityDataTable); //var PageList = new StaticPagedList<Product>(dataList, pager.PageNo, pager.PageSize, pager.Amount); //return View(PageList); int rid = int.Parse(Session["renid"].ToString()); Pager pager = new Pager(); pager.table = "RenkongList"; pager.strwhere = "Shenqingren=" + rid + " and Status='true'"; pager.PageSize = 12; pager.PageNo = page ?? 1; pager.FieldKey = "Id"; pager.FiledOrder = "Id desc"; pager = CommonDal.GetPager(pager); IList <RenKongList> dataList = DataConvertHelper <RenKongList> .ConvertToModel(pager.EntityDataTable); var PageList = new StaticPagedList <RenKongList>(dataList, pager.PageNo, pager.PageSize, pager.Amount); return(View(PageList)); }
public int ExecuteTransSql(Dictionary <String, List <CustomSqlParam> > sqlDirectionary) { using (CommonDal Access = new CommonDal(_dct)) { return(Access.ExecuteTransSql(sqlDirectionary)); } }
public DataSet GetDataSetByPage(string FieldList, string SearchCondition, string orderStr, int PageIndex, int PageSize) { DataSet ds = null; try { if (SearchCondition.Length > 0) { SearchCondition = " WHERE " + SearchCondition; } using (CommonDal Access = new CommonDal(_dct)) { ds = Access.GetPageDataByParameterizedSql(model.paramList, SMSCheckSystemListModel.TableName, FieldList, SearchCondition, orderStr, PageIndex, PageSize); } } catch (Exception ex) { ds = null; this._infomation = ex.Message; } return(ds); }
public ActionResult GetMemberShip() { CommonDal _da = null; string memberShipId = Session["MemberShipId"].ToString(); try { _da = new CommonDal(); List <MemberShip> gliList = new List <MemberShip>(); gliList = _da.GetMemberShip(memberShipId); if (gliList.Count > 0) { } else { return(RedirectToAction("Error", "Home")); } return(View(gliList)); } catch (Exception ex) { _da.ExceptionDtls(ex.Message, ex.GetType().ToString(), ex.StackTrace); return(RedirectToAction("Error", "Home")); } finally { _da = null; } }
public static IList <AdsCustomer> GetListForPageList(Pager pager) { pager = CommonDal.GetPager(pager); IList <AdsCustomer> customerList = DataConvertHelper <AdsCustomer> .ConvertToModel(pager.EntityDataTable); return(customerList); }
public static Pager SelectAll(string DtoName, Pager pager) { IMapping Mapping = MappingFactory.CreatMapping(DtoName); pager = CommonDal.GetPager(pager); return(pager); }
public ActionResult UCenter(int?page) { if (Session["uid"].ToString() != "" && Session["uid"] != null) { int uid = int.Parse(Session["uid"].ToString()); Ren ren = unitOfWork.rensRepository.GetByID(uid); ViewData["user"] = ren; var yings = unitOfWork.yingsRepository.Get(); Pager pager = new Pager(); pager.table = "YingList"; pager.strwhere = "Canjiaren=" + int.Parse(Session["uid"].ToString()); pager.PageSize = 15; pager.PageNo = page ?? 1; pager.FieldKey = "Id"; pager.FiledOrder = "Id desc"; pager = CommonDal.GetPager(pager); IList <YingList> dataList = DataConvertHelper <YingList> .ConvertToModel(pager.EntityDataTable); var PageList = new StaticPagedList <YingList>(dataList, pager.PageNo, pager.PageSize, pager.Amount); ViewBag.Amount = pager.Amount; return(View(PageList)); } else { return(RedirectToAction("Login", "Account")); } }
public DataSet GetDataSet(string SearchField, string SearchCondition) { DataSet ds = null; try { string strSQL = " SELECT " + " " + SearchField + " FROM " + SMSCheckSystemListModel.TableName; if (SearchCondition.Length > 0) { strSQL += " WHERE " + SearchCondition; } using (CommonDal Access = new CommonDal(_dct)) { ds = Access.GetDataByParameterizedSql(strSQL, model.paramList); } } catch (Exception ex) { ds = null; this._infomation = ex.Message; } return(ds); }
public static IList <AdsVideo> GetListForPageList(Pager pager) { pager = CommonDal.GetPager(pager); IList <AdsVideo> videoList = DataConvertHelper <AdsVideo> .ConvertToModel(pager.EntityDataTable); return(videoList); }
public User UpdateUserBL(User objUserBL) // passing Bussiness object Here { string spName = "[UpdateInfo]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.VarChar, objUserBL.id)); sqlParameters.Add(DBClient.AddParameters("firstname", SqlDbType.VarChar, objUserBL.FirstName)); sqlParameters.Add(DBClient.AddParameters("lastname", SqlDbType.VarChar, objUserBL.LastName)); sqlParameters.Add(DBClient.AddParameters("email", SqlDbType.VarChar, objUserBL.Email)); sqlParameters.Add(DBClient.AddParameters("phone", SqlDbType.VarChar, objUserBL.Mobile_no)); sqlParameters.Add(DBClient.AddParameters("dob", SqlDbType.VarChar, objUserBL.Dob)); sqlParameters.Add(DBClient.AddParameters("age", SqlDbType.VarChar, objUserBL.Age)); sqlParameters.Add(DBClient.AddParameters("path", SqlDbType.VarChar, objUserBL.Profile_picture_path)); sqlParameters.Add(DBClient.AddParameters("category", SqlDbType.VarChar, objUserBL.Category)); sqlParameters.Add(DBClient.AddParameters("title", SqlDbType.VarChar, objUserBL.Job_title)); sqlParameters.Add(DBClient.AddParameters("experience", SqlDbType.VarChar, objUserBL.Experience)); sqlParameters.Add(DBClient.AddParameters("skills", SqlDbType.VarChar, objUserBL.Skills)); sqlParameters.Add(DBClient.AddParameters("currentsalary", SqlDbType.VarChar, objUserBL.Current_salary)); sqlParameters.Add(DBClient.AddParameters("expectedsalary", SqlDbType.VarChar, objUserBL.Expected_salary)); sqlParameters.Add(DBClient.AddParameters("state", SqlDbType.VarChar, objUserBL.State)); sqlParameters.Add(DBClient.AddParameters("city", SqlDbType.VarChar, objUserBL.City)); sqlParameters.Add(DBClient.AddParameters("address", SqlDbType.VarChar, objUserBL.Address)); User updateinfo = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray()); return(updateinfo); }
public static DataTable SelectSome(string DtoName, string table, string strWhere) { IMapping Mapping = MappingFactory.CreatMapping(DtoName); DataTable dt = CommonDal.GetSomeByWhere(table, strWhere); return(dt); }
public static int GetSomeValue(string DtoName, string table, string strWhere, string thevalue) { int count = 0; count = CommonDal.GetSomeValueByWhere(table, strWhere, thevalue); return(count); }
public List <Industry_Type> GetJobCountByIndustry() { string spName = "[FetchindustryCount]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <Industry_Type> jobData = CommonDal.ExecuteProcedure <Industry_Type>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public List <JobPost> GetJobPost() { string spName = "[FetchJobPost]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public void DeleteLanguage(int id) { string spName = "[DeleteLanguage]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); CommonDal.Crud(spName, sqlParameters.ToArray()); }
public static Message UpdateFieldOneByOne(string DtoName, string table, string strWhere, string columnname, string columnvalue) { Message msg = new Message(); IMapping Mapping = MappingFactory.CreatMapping(DtoName); msg.MessageInfo = CommonDal.SetFiledOneByOne(table, strWhere, columnname, columnvalue); return(msg); }
public List <State> GetJobCountByState() { string spName = "[FetchLocationCount]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <State> jobData = CommonDal.ExecuteProcedure <State>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public List <Category> GetJobCountByCategory() { string spName = "[FetchCategoryCount]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <Category> jobData = CommonDal.ExecuteProcedure <Category>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public List <Company> GetCompany() { string spName = "[FetchCompany]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <Company> jobData = CommonDal.ExecuteProcedure <Company>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public void RemoveAppliedJob(int id) { string spName = "[RemoveAppliedJob]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); CommonDal.Crud(spName, sqlParameters.ToArray()); }
public static Message Delete(string DtoName, string table, string strWhere) { Message msg = new Message(); IMapping Mapping = MappingFactory.CreatMapping(DtoName); msg.MessageInfo = CommonDal.Delete(table, strWhere); return(msg); }
public JobPost GetJobPost_by_id(int id) { string spName = "[GetPostJobInfo_By_id]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); JobPost jobData = CommonDal.SelectObject <JobPost>(spName, sqlParameters.ToArray()); return(jobData); }
public Company GetCompany_by_id(int id) { string spName = "[GetCompanyInfo_By_id]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); Company company = CommonDal.SelectObject <Company>(spName, sqlParameters.ToArray()); return(company); }
public User GetData(int id) { string spName = "[GetData]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); User jobData = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray()); return(jobData); }
public User GetForgotPassword(User ObjUser) { string spName = "[ForGotPassword]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("Email", SqlDbType.VarChar, ObjUser.Email)); User jobData = CommonDal.SelectObject <User>(spName, sqlParameters.ToArray()); return(jobData); }
public List <Category> GetCategory(int id) { string spName = "[FetchCategories]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("id", SqlDbType.Int, id)); IList <Category> roleList = CommonDal.ExecuteProcedure <Category>(spName, sqlParameters.ToArray()); return(roleList.ToList()); }
public List <JobPost> GetAppliedJob_byId(int id) { string spName = "[FetchAppliedJob]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("u_id", SqlDbType.VarChar, Convert.ToInt32(id))); List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }
public List <JobPost> GetJobBy_LocationId(int id) { string spName = "[FetchJobByLocationId]"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(DBClient.AddParameters("s_id", SqlDbType.Int, id)); List <JobPost> jobData = CommonDal.ExecuteProcedure <JobPost>(spName, sqlParameters.ToArray()).ToList(); return(jobData); }