public ActionResult Details(int id)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("_id", id);
return(View(DapperORM.ReturnList <Categoria>("CategoriaViewById", parameters).FirstOrDefault()));
}
// type = USER_NAME, HR_ID_C, AGENT_ID_C
public bool checkUserExist(string type, string value, string id)
{
DynamicParameters param = new DynamicParameters();
String sql = "Select count(ID) from vwUSERS where ID != @id";
if (type == "USER_NAME")
{
sql += " AND USER_NAME = @username";
param.Add("@username", value);
}
if (type == "HR_ID_C")
{
sql += " AND HR_ID_C = @HR_ID_C ";
param.Add("@HR_ID_C", value);
}
if (type == "AGENT_ID_C")
{
sql += " AND AGENT_ID_C = @AGENT_ID_C ";
param.Add("@AGENT_ID_C", value);
}
param.Add("@id", id);
int user = DapperORM.Count(sql, param);
return(user > 0);
}
public ActionResult VerTodosProdutos(int Id)
{
DynamicParameters param = new DynamicParameters();
param.Add("@IdProduto", Id);
return(View(DapperORM.ReturnList <Produto>("VerTodosProdutos")));
}
public JsonResult SetHoldem(IFormCollection form)
{
Hashtable jsonReturn = new Hashtable();
//var User = HttpContext.Request.Form["User"];
//var gNum = HttpContext.Request.Form["gNum"];
var gNum = Convert.ToInt16(form["gNum"]);
var Rand = Convert.ToInt16(form["Rand"]);
var Card = form["User"].ToString();
var User = "";
foreach (var item in form["User"].Select((value, index) => new { Value = value, Index = index }))
{
User += (item.Index == (form["User"].Count - 1)) ? Convert.ToString(item.Index) : Convert.ToString(item.Index) + ",";
}
DynamicParameters param = new DynamicParameters();
param.Add("@GameKind", gNum);
param.Add("@Rand", Rand);
param.Add("@Card", Card);
param.Add("@UserCard", User);
param.Add("@UserIP", HttpContext.Connection.RemoteIpAddress.ToString());
param.Add("@rCnt", 0, DbType.Int16, ParameterDirection.Output);
param.Add("@rVal", "", DbType.String, ParameterDirection.Output);
var DataResult = DapperORM.ReturnList <dynamic>("WSP_TEST_GameCardSetting", param, _StrConn);
jsonReturn.Add("rCnt", param.Get <Int16>("@rCnt"));
jsonReturn.Add("rVal", param.Get <string>("@rVal"));
return(Json(jsonReturn));
}
public JsonResult SetAdLogin(Models.Man.adMember mParams)
{
Hashtable jsonReturn = new Hashtable();
DynamicParameters param = new DynamicParameters();
param.Add("@ad_id", mParams.ad_id);
param.Add("@ad_pw", mParams.ad_pw);
param.Add("@ad_ip", mParams.ad_ip);
param.Add("@rCnt", -1, DbType.Int16, ParameterDirection.Output);
param.Add("@rVal", "", DbType.String, ParameterDirection.Output);
var DataResult = DapperORM.ReturnList <dynamic>("WSP_ADMEMBER_LOGIN", param, _StrConn);
if (DataResult.Count() > 0)
{
HttpContext.Session.SetInt32("ad_idx", (Int32)DataResult.First().ad_idx);
HttpContext.Session.SetString("ad_id", mParams.ad_id);
HttpContext.Session.SetString("ad_name", (string)DataResult.First().ad_name);
HttpContext.Session.SetInt32("ad_level", (int)DataResult.First().ad_level);
HttpContext.Session.SetInt32("ad_use", (int)DataResult.First().ad_use);
jsonReturn.Add("rCnt", param.Get <Int16>("@rCnt"));
jsonReturn.Add("rVal", param.Get <string>("@rVal"));
}
else
{
jsonReturn.Add("rCnt", 1);
jsonReturn.Add("rVal", "아이디 및 비밀번호가 일치하지 않아 로그인에 실패했습니다.");
}
return(Json(DataResult));
}
public ActionResult ArticleDetails(int id)
{
if (id == 0)
{
throw new ArgumentException($"Невозможно открыть статью с id=0 для чтения");
}
DynamicParameters articleParam = new DynamicParameters();
articleParam.Add("@ArticleId", id);
ArticlesModel articleModel = DapperORM.ReturnList <ArticlesModel>("GetArticleById", articleParam).FirstOrDefault <ArticlesModel>();
if (articleModel == null)
{
throw new ArgumentException($"Не удалось найти статью с id={id} в базе данных");
}
DynamicParameters commentParam = new DynamicParameters();
commentParam.Add("@ArticleId", id);
List <CommentsModel> commentsModelList = DapperORM.ReturnList <CommentsModel>("GetCommentsByArticleId", commentParam).ToList();
foreach (CommentsModel commentModel in commentsModelList)
{
RecursiveAddChildComments(articleModel.Id, commentModel);
}
articleModel.Comments = commentsModelList;
return(View(articleModel));
}
public ActionResult Edit(EmpClass empClass)
{
try
{
DynamicParameters param = new DynamicParameters();
string createdby = HttpContext.User.Identity.Name;
string updatedby = HttpContext.User.Identity.Name;
param.Add("@Id", empClass.Id);
param.Add("@EmpName", empClass.Empname);
param.Add("@Empemail", empClass.Empemail);
param.Add("@Emplocation", empClass.Emplocation);
param.Add("@Empdesignation", empClass.Empdesignation);
param.Add("@UserName", empClass.UserName);
param.Add("@Password", empClass.Password);
param.Add("@IsActive", empClass.IsActive);
param.Add("@Role", empClass.Role);
param.Add("@squad", empClass.Squad);
param.Add("@CreatedDate", empClass.CreatedDate);
param.Add("@CreatedBy", createdby);
param.Add("@UpdatedDate", empClass.UpdatedDate);
param.Add("@Updatedby", updatedby);
DapperORM.ExecuteWithoutReturn("AddUpdateEmp", param);
return(RedirectToAction("Index"));
}
catch (Exception)
{
ViewBag.message = "Invalid Credentials";
return(View());
}
}
public ActionResult AddOrEdit(Cliente c)
{
DynamicParameters param = new DynamicParameters();
param.Add("@Id", c.Id);
param.Add("@Nome", c.Nome);
param.Add("@Email", c.Email);
param.Add("@CPF", c.CPF);
param.Add("@ProdutoId", c.ProdutoId);
param.Add("@Produto", c.Produto);
var check = DapperORM.ExcecuteQuery("ClienteAddorEdit", param);
if (check)
{
ViewBag.Check = true;
Cliente cliente = new Cliente
{
Produtos = ListarProdutos(false)
};
return(View(cliente));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Preview(int id)
{
DynamicParameters param = new DynamicParameters();
param.Add("@InvoiceId", id);
return(View(DapperORM.ReturnList <InvoicePreviewViewModel>("sp_invoice_preview_by_id", param).FirstOrDefault <InvoicePreviewViewModel>()));
}
public bool IsTeamExist(string ID, string NAME)
{
DynamicParameters param = new DynamicParameters();
string conditionSql = "";
string sql = "Select count(*) from vwTEAMS where 1 = 1";
if (ID == null)
{
return(false);
}
conditionSql += " and ID = @ID";
param.Add("@ID", new Guid(ID));
if (NAME != null)
{
conditionSql += " and NAME = @NAME";
param.Add("@NAME", NAME);
}
sql += conditionSql;
int total = DapperORM.Count(sql, param);
if (total != 0)
{
return(true);
}
else
{
return(false);
}
}
public string AddStudent(tbl_MCE_Student_Basic MCE_Student_Basic)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "STUDENTINS");
param.Add("@P_vchName", MCE_Student_Basic.vchName);
param.Add("@P_vchUserName", MCE_Student_Basic.vchUserName);
param.Add("@P_vchPassword ", Util.GetHashByte(MCE_Student_Basic.vchPassword));
param.Add("@P_intRoleID", MCE_Student_Basic.intRoleID);
param.Add("@P_intLevelID", MCE_Student_Basic.intLevelID);
param.Add("@P_vchAdmissionBatch", MCE_Student_Basic.vchAdmissionBatch);
param.Add("@P_intCourseID", MCE_Student_Basic.intCourseID);
param.Add("@P_vchCourseName", MCE_Student_Basic.vchCourseName);
param.Add("@P_intBranchID", MCE_Student_Basic.intBranchID);
param.Add("@P_vchBranchName", MCE_Student_Basic.vchBranchName);
param.Add("@P_intSemister", MCE_Student_Basic.intSemister);
param.Add("@P_intJoinCategoryID", MCE_Student_Basic.intJoinCategoryID);
param.Add("@P_dtmDOB", MCE_Student_Basic.dtmDOB);
param.Add("@P_vchGender", MCE_Student_Basic.vchGender);
param.Add("@P_vchRemarks", MCE_Student_Basic.vchRemarks);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_STUDENT_DLM", param, "@P_VCHMSGOUT"));
}
public bool DeleteTSRFromTeam(string TSR_ID, string USER_ID)
{
try
{
//sql 1
string updateUsersCstmSql = "update USERS_CSTM set GROUP_ID_C = NULL where ID_C = @ID";
DynamicParameters paramsUpdateUserCstmSql = new DynamicParameters();
paramsUpdateUserCstmSql.Add("@ID", new Guid(TSR_ID));
SqlForm[] sqlForms = new SqlForm[2];
sqlForms[0] = new SqlForm(updateUsersCstmSql, paramsUpdateUserCstmSql);
//sql 2
string updateUsersSql = "update USERS set DATE_MODIFIED = @DATE_MODIFIED, MODIFIED_USER_ID = @MODIFIED_USER_ID where ID = @ID";
DynamicParameters paramUpdateUsersSql = new DynamicParameters();
paramUpdateUsersSql.Add("@ID", new Guid(TSR_ID));
paramUpdateUsersSql.Add("@MODIFIED_USER_ID", new Guid(USER_ID));
paramUpdateUsersSql.Add("@DATE_MODIFIED", DateTime.Now);
sqlForms[1] = new SqlForm(updateUsersSql, paramUpdateUsersSql);
DapperORM.ExecuteTransaction(sqlForms);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return(false);
}
}
public string AddPlinks(tbl_MCE_PrimaryLink mce_Primarylink)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "PRIMARYLINKINSERT");
param.Add("@p_vchPLinkName", mce_Primarylink.vchPLinkName);
param.Add("@p_intGLinkID", mce_Primarylink.intGLinkID);
param.Add("@p_intFunctionID", mce_Primarylink.intFunctionID);
param.Add("@p_intSlNo", mce_Primarylink.intSlNo);
param.Add("@p_vchExternalURL", mce_Primarylink.vchExternalURL);
param.Add("@p_bitLinkType ", mce_Primarylink.bitLinkType);
param.Add("@p_bitShowOnHomePage", mce_Primarylink.bitShowOnHomePage);
param.Add("@p_intAccessID", mce_Primarylink.intAccessID);
param.Add("@p_intAccess ", mce_Primarylink.intAccess);
param.Add("@p_intUserID", mce_Primarylink.intUserID);
param.Add("@p_vchAction1", mce_Primarylink.vchAction1);
param.Add("@p_vchIcon", mce_Primarylink.vchIcon);
param.Add("@P_vchRemarks", mce_Primarylink.vchRemarks);
param.Add("@P_intCreatedBy", mce_Primarylink.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Primarylink_DML", param, "@P_VCHMSGOUT"));
throw new NotImplementedException();
}
public IEnumerable <CampConfigListDto> GetCampConfigList(string campaignIdC, int?check)
{
DynamicParameters param = new DynamicParameters();
string query =
"Select " +
"NAME, DATA_TYPE, DB_FIELD_NAME_C, MODULE_C " +
"from vwCAMP_CONFIG_LIST " +
"where STT IS NOT NULL ";
if (!string.IsNullOrEmpty(campaignIdC))
{
query += " and CAMPAIGN_ID_C = @CAMPAIGN_ID_C";
}
if (check != null)
{
query += " and CHECKED = @CHECKED";
}
param.Add("@CAMPAIGN_ID_C", campaignIdC);
param.Add("@CHECKED", check);
query += " ORDER BY STT ASC";
var data = DapperORM.ExcecuteReturnList <CampConfigListDto>(query, param);
// ()
return(data);
}
//Api cập nhật lại chỉ tiêu cho list user thuộc nhóm được phân bổ
public ResponseForm <string> UpdateTableAgentTarget(UpdateAgentTargetDto input)
{
try
{
DynamicParameters param = new DynamicParameters();
string sql = "UPDATE AGENT_TARGET SET " +
"TOTAL_NUM = @TOTAL_NUM, " +
"AGREE_NUM = @AGREE_NUM, " +
"REACTIVE_NUM = @REACTIVE_NUM, " +
"CONNECTED_NUM = @CONNECTED_NUM " +
"Where TEAM_TARGET_ID = @TEAM_TARGET_ID ";
param.Add("@TOTAL_NUM", input.TOTAL_NUM);
param.Add("@AGREE_NUM", input.AGREE_NUM);
param.Add("@REACTIVE_NUM", input.REACTIVE_NUM);
param.Add("@CONNECTED_NUM", input.CONNECTED_NUM);
param.Add("@TEAM_TARGET_ID", input.TEAM_TARGET_ID);
DapperORM.Execute(sql, param);
return(new ResponseForm <string>(input.TEAM_TARGET_ID));
}
catch (Exception ex)
{
return(new ResponseForm <string>(input.TEAM_TARGET_ID, ex.Message, 600));
}
}
public ActionResult Create(Invoice invoice)
{
if (invoice.InvoiceId != 0)
{
DynamicParameters param = new DynamicParameters();
param.Add("InvoiceId", invoice.InvoiceId);
param.Add("CustomerId", invoice.CustomerId);
param.Add("PurchaseOrder", invoice.PurchaseOrder);
param.Add("InvoiceDate", invoice.InvoiceDate);
param.Add("PaymentTermsId", invoice.PaymentTermsId);
param.Add("SalesTaxRate", invoice.SalesTaxRate);
param.Add("Discount", invoice.Discount);
param.Add("Comments", invoice.Comments);
param.Add("IsActive", invoice.IsActive);
DapperORM.ExecuteWithoutReturn("sp_invoice_update", param);
}
else
{
DynamicParameters param = new DynamicParameters();
param.Add("CustomerId", invoice.CustomerId);
param.Add("PurchaseOrder", invoice.PurchaseOrder);
param.Add("InvoiceDate", invoice.InvoiceDate);
param.Add("PaymentTermsId", invoice.PaymentTermsId);
param.Add("SalesTaxRate", invoice.SalesTaxRate);
param.Add("Discount", invoice.Discount);
param.Add("Comments", invoice.Comments);
param.Add("IsActive", invoice.IsActive);
DapperORM.ExecuteWithoutReturn("sp_invoice_insert", param);
}
return(RedirectToAction("Index"));
}
public IEnumerable <Course_DDL> CourseList1()
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "CLD");
return(DapperORM.ReturnList <Course_DDL>("SP_MCE_Course_Report", param));
}
public IEnumerable <Employee_DDL> EmployeeList1()
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "ELD");
return(DapperORM.ReturnList <Employee_DDL>("SP_MCE_Employee_Report", param));
}
//GET: User/Heklijo/MyTickets/TicketDetails/5
public ActionResult TicketDetails(int id)
{
MyTicketViewModel model = DapperORM.getSingleTicketData(id);
model.teams = DapperORM.getTeamData();
return(View(model));
}
public string Editemployee(tbl_MCE_Employee mce_Employee)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "EMPLOYEEUPDATE");
param.Add("@P_intID", mce_Employee.intID);
param.Add("@P_vchEmployeeCode", mce_Employee.vchEmployeeCode);
param.Add("@P_vchName", mce_Employee.vchName);
param.Add("@P_dtDOJ ", mce_Employee.dtDOJ);
param.Add("@P_intJoinCategoryID", mce_Employee.intJoinCategoryID);
param.Add("@P_intCourseID", mce_Employee.intCourseID);
param.Add("@p_vchCourseName", mce_Employee.vchCourseName);
param.Add("@P_intBranchID", mce_Employee.intBranchID);
param.Add("@p_vchBranchName", mce_Employee.vchBranchName);
param.Add("@P_intDesignationID", mce_Employee.intDesignationID);
param.Add("@P_vchDesignation", mce_Employee.vchDesignation);
param.Add("@P_intRoleID ", mce_Employee.intRoleID);
param.Add("@P_intLevelID", mce_Employee.intLevelID);
param.Add("@P_intRAID", mce_Employee.intRAID);
param.Add("@P_intApprovalByID ", mce_Employee.intApprovalByID);
param.Add("@P_vchGender", mce_Employee.vchGender);
param.Add("@P_vchHighestQualification ", mce_Employee.vchHighestQualification);
param.Add("@P_decExperienceAsJoiningDate ", mce_Employee.decExperienceAsJoiningDate);
param.Add("@P_vchRemarks ", mce_Employee.vchRemarks);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Employee_DML", param, "@P_VCHMSGOUT"));
}
public ResponseListForm <RoleTLS> GetRolesList(string NAME, string REGION_C, string REGION_ID_C)
{
try
{
DynamicParameters param = new DynamicParameters();
String sql = "SELECT ID, NAME, DESCRIPTION, DATE_ENTERED FROM vwROLES_TLS_List where 1 = 1 ";
if (!string.IsNullOrEmpty(NAME))
{
sql += " and NAME LIKE N'%' + @NAME + '%'";
param.Add("@NAME", Security.Encode(NAME));
}
if (!string.IsNullOrEmpty(REGION_C))
{
sql += " and REGION_C LIKE N'%' + @REGION_C + '%'";
param.Add("@REGION_C", REGION_C);
}
if (!string.IsNullOrEmpty(REGION_ID_C))
{
sql += " and REGION_ID_C LIKE N'%' + @REGION_ID_C + '%'";
param.Add("@REGION_ID_C", REGION_ID_C);
}
var listRole = DapperORM.ExcecuteReturnList <RoleTLS>(sql, param);
return(new ResponseListForm <RoleTLS>(listRole, new Pagination()));
}
catch (Exception ex)
{
return(new ResponseListForm <RoleTLS>(null, ex.Message, 600));
}
}
//To add new semester
public string AddSemester(tbl_MCE_Semester mce_Semester)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "SEMESTERINSERT");
param.Add("@P_vchAdmissionBatch", mce_Semester.vchAdmissionBatch);
param.Add("@P_intCourseID", mce_Semester.intCourseID);
param.Add("@P_intBranchID", mce_Semester.intBranchID);
param.Add("@p_vchCourseName", mce_Semester.vchCourseName);
param.Add("@p_vchBranchName", mce_Semester.vchBranchName);
param.Add("@P_intSemester", mce_Semester.intSemester);
param.Add("@P_vchSection", mce_Semester.vchSection);
param.Add("@P_dtmStartDate", mce_Semester.dtmStartDate);
param.Add("@P_dtmEndDate", mce_Semester.dtmEndDate);
param.Add("@P_vchRemarks", mce_Semester.vchRemarks);
param.Add("@P_intCreatedBy", mce_Semester.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return(DapperORM.ExecuteDML("SP_MCE_Semester_DML", param, "@P_VCHMSGOUT"));
}
public JsonResult SetRoulette(IFormCollection form)
{
Hashtable jsonReturn = new Hashtable();
var gNum = Convert.ToInt16(form["gNum"]);
var Rand = Convert.ToInt16(form["Rand"]);
//var Card = form["User"].ToString();
//var User = "******";
var Card = form["User"].ToString();
var User = form["UserColor"].ToString();
DynamicParameters param = new DynamicParameters();
param.Add("@GameKind", gNum);
param.Add("@Rand", Rand);
param.Add("@Card", Card);
param.Add("@UserCard", User);
param.Add("@UserIP", HttpContext.Connection.RemoteIpAddress.ToString());
param.Add("@rCnt", 0, DbType.Int16, ParameterDirection.Output);
param.Add("@rVal", "", DbType.String, ParameterDirection.Output);
var DataResult = DapperORM.ReturnList <dynamic>("WSP_TEST_GameCardSetting", param, _StrConn);
jsonReturn.Add("rCnt", param.Get <Int16>("@rCnt"));
jsonReturn.Add("rVal", param.Get <string>("@rVal"));
return(Json(jsonReturn));
}
public IEnumerable <object> FindTitle(string name, string nameUserTitle, string regionIdC)
{
//NAME like @name
//and NAME_USERTITLE like @nameUserTitle
//
string sql = "Select ID,NAME,NAME_USERTITLE,DESCRIPTION from vwTITLE where REGION_ID_C = @regionIdC";
DynamicParameters param = new DynamicParameters();
param.Add("@regionIdC", new Guid(regionIdC));
if (!string.IsNullOrEmpty(name))
{
sql += " and NAME like @name";
param.Add("@name", "%" + Security.Encode(name) + "%");
}
if (!string.IsNullOrEmpty(nameUserTitle))
{
sql += " and NAME_USERTITLE like @nameUserTitle";
param.Add("@nameUserTitle", "%" + Security.Encode(nameUserTitle) + "%");
}
sql += " order by DATE_ENTERED DESC;";
return(DapperORM.ExcecuteReturnList <object>(sql, param));
}
public UserLoginDto findUserByUsernameAndPassword(string username, string password)
{
bool isCheckLDap = false;
string sql = "Select * from USERS where USER_NAME = @username";
DynamicParameters param = new DynamicParameters();
if (isCheckLDap)
{
// do login function with LDAP
param.Add("@USER_NAME", username);
sql = "select * "
+ " from vwUSERS_Login "
+ " where lower(USER_NAME) = @USER_NAME";
}
else
{
string passwordHashed = Security.HashPassword(password);
param.Add("@USER_HASH", passwordHashed);
param.Add("@USER_NAME", username);
sql = "select * from vwUSERS_Login where lower(USER_NAME) = @USER_NAME and lower(USER_HASH) = @USER_HASH;";
}
Console.WriteLine("sql:" + sql);
var user = DapperORM.ExcecuteReturnScalar <UserLoginDto>(sql, param);
return(user);
}
public bool CreateCoefficient(CreateCoefficientDto createCoefficientDto)
{
DynamicParameters param = new DynamicParameters();
try
{
String sql = @"
INSERT INTO TITLE_CAMPAIGN_CATEGORY(ID,DELETED,CREATED_BY,DATE_ENTERED,MODIFIED_USER_ID,DATE_MODIFIED,DATE_MODIFIED_UTC,CAMPAIGN_CATEGORY_ID,TITLE_ID,COEFFICIENT,TOTAL_NUM,CONNECTED_NUM,AGREE_NUM)
VALUES(@id, @deleted, @createdBy, @dateEntered,@modifiedUserId,@dateModified,@dateModifiedUTC,@campaignCategoryId,@titleId,@coEfficient,@totalNum,@connectedNum,@agreeNum)";
param.Add("@id", createCoefficientDto.ID);
param.Add("@deleted", createCoefficientDto.DELETED);
param.Add("@createdBy", createCoefficientDto.CREATED_BY);
param.Add("@dateEntered", createCoefficientDto.DATE_ENTERED);
param.Add("@modifiedUserId", createCoefficientDto.MODIFIED_USER_ID);
param.Add("@dateModified", createCoefficientDto.DATE_MODIFIED);
param.Add("@dateModifiedUTC", createCoefficientDto.DATE_MODIFIED_UTC);
param.Add("@campaignCategoryId", createCoefficientDto.CAMPAIGN_CATEGORY_ID);
param.Add("@titleId", createCoefficientDto.TITLE_ID);
param.Add("@coEfficient", createCoefficientDto.COEFFICIENT);
param.Add("@totalNum", createCoefficientDto.TOTAL_NUM);
param.Add("@connectedNum", createCoefficientDto.CONNECTED_NUM);
param.Add("@agreeNum", createCoefficientDto.AGREE_NUM);
DapperORM.Execute(sql, param);
return(true);
}
catch (Exception e)
{
Console.WriteLine("ex:" + e);
return(false);
}
}
public string AddSubject(tbl_MCE_Subject mce_Subject)
{
DynamicParameters param = new DynamicParameters();
param.Add("@P_CHRACTION", "SUBJECTINSERT");
param.Add("@P_vchSubjectCode", mce_Subject.vchSubjectCode);
param.Add("@P_vchSubjectName", mce_Subject.vchSubjectName);
param.Add("@P_vchSubjectDescription", mce_Subject.vchSubjectDescription);
param.Add("@P_intCourseID", mce_Subject.intCourseID);
param.Add("@P_intBranchID", mce_Subject.intBranchID);
param.Add("@p_vchCourseName", mce_Subject.vchCourseName);
param.Add("@p_vchBranchCode", mce_Subject.vchBranchCode);
param.Add("@p_vchBranchName", mce_Subject.vchBranchName);
param.Add("@P_intSemister", mce_Subject.intSemister);
param.Add("@P_vchSubjectType", mce_Subject.vchSubjectType);
param.Add("@P_vchSubjectCategory", mce_Subject.vchSubjectCategory);
param.Add("@P_decCredit", mce_Subject.decCredit);
param.Add("@P_decHours", mce_Subject.decHours);
param.Add("@P_vchRemarks", mce_Subject.vchRemarks);
param.Add("@P_intCreatedBy", mce_Subject.intCreatedBy);
param.Add("@P_VCHMSGOUT", dbType: DbType.String, direction: ParameterDirection.Output, size: 5215585);
return DapperORM.ExecuteDML("SP_MCE_Subject_DML", param, "@P_VCHMSGOUT");
}
//
//thanh - sunivy
//12/12/2020
public ConfigLdapDto GetConfigLdap()
{
try
{
DynamicParameters paramConfig = new DynamicParameters();
String sqlConfig = @"select NAME,VALUE from CONFIG where CATEGORY = 'LDAP' ";
var dtConfigDto = DapperORM.ExcecuteReturnList <ConfigDto>(sqlConfig, paramConfig);
ConfigLdapDto configLdapDto = new ConfigLdapDto();
foreach (var rdr in dtConfigDto)
{
if (rdr.NAME == "UrlLDAP")
{
configLdapDto.UrlLDAP = rdr.VALUE;
}
else if (rdr.NAME == "UserLDAP")
{
configLdapDto.UserLDAP = rdr.VALUE;
}
else if (rdr.NAME == "PassLDAP")
{
configLdapDto.PassLDAP = rdr.VALUE;
}
}
return(configLdapDto);
}
catch (Exception e)
{
throw e;
}
}
public void Initialize()
{
Orm = new DapperORM();
guilds = Orm.GetGuildEngines().ToDictionary(x => x.Id);
NewGuilds = new List <GuildEngine>();
Task.Factory.StartNewDelayed(15 * 1000, Save);
}
// GET: Customer
public ActionResult Index()
{
List <Customers> lstCustomers = new List <Customers>();
lstCustomers = DapperORM.ReturnList <Customers>("spGetCustomers", null).ToList();
return(View(lstCustomers));
}
