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);
}
