public string SaveUserTemplateMapping(UserTemplateMapping objUserTemplateMapping) { var sqlHelper = GetDBConnection(1); var ds = sqlHelper.ExecuteDataSet(Constants.Tech_SaveUserTemplateMapping, objUserTemplateMapping.UserId, objUserTemplateMapping.TemplateId, objUserTemplateMapping.isWrite); //var dt = ds.Tables[0]; //var op = Convert.ToString(dt.Rows[0]["outputt"].ToString()); return(""); }
public List <UserTemplateMapping> GetAllUserTemplateMapping(int userid = 0) { var sqlHelper = GetDBConnection(1); var dataSet = sqlHelper.ExecuteDataSet(Constants.Tech_GetAllUserTemplateMapping, userid); var dt = dataSet.Tables[0]; List <UserTemplateMapping> usertemplist = new List <UserTemplateMapping>(); for (int i = 0; i < dt.Rows.Count; i++) { UserTemplateMapping objum = new UserTemplateMapping(); objum.UserId = Convert.ToInt32(dt.Rows[i]["Userid"]); objum.TemplateId = Convert.ToInt32(dt.Rows[i]["TemplateId"].ToString()); objum.TemplateName = Convert.ToString(dt.Rows[i]["TemplateName"].ToString()); objum.isWrite = Convert.ToBoolean(dt.Rows[i]["isWrite"].ToString()); objum.UserName = Convert.ToString(dt.Rows[i]["UserName"]); usertemplist.Add(objum); } return(usertemplist); }