public int Save(KeHoachCT keHoachCT)
{
const string storeName = "st_UpdateKeHoachCT";
const string storeNameThamDu = "st_InsertThamDu";
const string storeNameDeleteThamDu = "st_DeleteThamDu";
int idKeHoach = 0;
using (var conn = new AdoHelper())
{
conn.BeginTransaction();
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@TenKeHoach", keHoachCT.TenKeHoach),
new SqlParameter("@UserName", keHoachCT.UserName),
new SqlParameter("@TuNgay", keHoachCT.TuNgayModel),
new SqlParameter("@TuGio", keHoachCT.TuGio),
new SqlParameter("@DenGio", keHoachCT.DenGio),
new SqlParameter("@DenNgay", keHoachCT.DenNgayModel),
new SqlParameter("@KeHoachCongTac", keHoachCT.KeHoachCongTac),
new SqlParameter("@DiaDiem", keHoachCT.DiaDiem),
new SqlParameter("@MucDo", keHoachCT.MucDo),
new SqlParameter("@LapLai", keHoachCT.LapLai),
new SqlParameter("@Deadline", keHoachCT.Deadline),
};
conn.ExecNonQueryProc(storeName, objectParam);
SqlParameter[] objectDeleteThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
};
conn.ExecNonQueryProc(storeNameDeleteThamDu, objectDeleteThamDu);
if (keHoachCT.ThamDu != null && (keHoachCT.ThamDu.Count() > 0))
{
foreach (var item in keHoachCT.ThamDu)
{
SqlParameter[] objectThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@NguoiThamDu", item),
new SqlParameter("@Kieu", 1),//Tham du
};
conn.ExecNonQueryProc(storeNameThamDu, objectThamDu);
}
}
if (keHoachCT.ChuTri != null && (keHoachCT.ChuTri.Count() > 0))
{
foreach (var item in keHoachCT.ChuTri)
{
SqlParameter[] objectThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@NguoiThamDu", item),
new SqlParameter("@Kieu", 2),//Chu Tri
};
conn.ExecNonQueryProc(storeNameThamDu, objectThamDu);
}
}
conn.Commit();
}
return(idKeHoach);
}
public ResultDto Delete(int GroupMeetingId, int userId)
{
ResultDto resultDto = new ResultDto();
string obectName = "GroupMeeting";
try
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@GroupMeetingId", GroupMeetingId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
parms[1] = new SqlParameter("@UserId", userId);
parms[1].SqlDbType = System.Data.SqlDbType.Int;
obj.ExecNonQueryProc("uspGroupMeetingDelete", parms);
resultDto.ObjectId = (int)parms[1].Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details deleted successfully", obectName);
}
else
{
resultDto.Message = string.Format("Error occured while deleting {0} details", obectName);
}
}
catch (Exception)
{
resultDto.Message = string.Format("Service layer error occured while deleting the {0} details", obectName);
resultDto.ObjectId = -98;
}
return(resultDto);
}
public int?AddEdit(string Sys_Id,
string Sys_Var,
string Sys_Type,
decimal?Sys_Value,
string Sys_Name,
bool?IsEditable,
string username)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_SysVar_insert_update",
"@Sys_Id", Sys_Id,
"@Sys_Var", Sys_Var,
"@Sys_Type", Sys_Type,
"@Sys_Name", Sys_Name,
"@Sys_Value", Sys_Value,
"@IsEditable", IsEditable,
"@UserName", username,
returnValue);
result = db.GetParamReturnValue(returnValue);
return(result);
}
}
public ResultDto DeleteLoanOBByMemberID(int memberid)
{
ResultDto resultDto = new ResultDto();
try
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@MemberID", memberid);
parms[0].SqlDbType = SqlDbType.Int;
int result = obj.ExecNonQueryProc("uspLoanMasterDeleteByMemberID", parms);
if (result > 0)
{
resultDto.ObjectCode = "LoanOB Record Deleted Successfully";
}
else
{
resultDto.ObjectCode = "Error Occuring While Deleting The LoanOB Record";
}
}
catch (Exception)
{
throw;
}
return(resultDto);
}
public int?Edit(string username, string password, string fullName, string email, int?groupId)
{
int?result;
string salt = null;
string encryptedPassword = null;
if (password.IsNotEmptyOrWhiteSpace())
{
encryptedPassword = SecurityHelper.EncryptPassword(password, out salt);
}
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_admin_users_update", "@UserName", username, "@Password", encryptedPassword, "@Salt", salt, "@FullName", fullName, "@Email", email, "@GroupId", groupId, returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
return(result);
}
public int?Edit(int pageId, int?pageParentId, string pageName, string target, string url, bool showInMenu, bool isActive, string cssClass, string groupsPermissions)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_admin_pages_update",
"@PageId", pageId,
"@PageParentId", pageParentId,
"@PageName", pageName,
"@Target", target,
"@Url", url,
"@ShowInMenu", showInMenu,
"@IsActive", isActive,
"@CssClass", cssClass,
"@GroupsPermissions", groupsPermissions,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
return(result);
}
public bool UpdateOB(int ahid, int groupid, decimal balance)
{
AccountHeadDto viewBalance = new AccountHeadDto();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[3];
parms[0] = new SqlParameter("@Ahid", ahid);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
parms[1] = new SqlParameter("@Balance", balance);
parms[1].SqlDbType = System.Data.SqlDbType.Decimal;
parms[2] = new SqlParameter("@GroupID", groupid);
parms[2].SqlDbType = System.Data.SqlDbType.Int;
int rowCount = obj.ExecNonQueryProc("uspGroupOBUpdate", parms);
if (rowCount > 0)
{
return(true);
}
else
{
return(false);
}
}
public int?ResetPassword(string passwordResetKey, string newPassword)
{
int?result = 2;
Subscription subscription = GetSubscriptionByPasswordResetKey(passwordResetKey);
if (subscription.IsNotNull())
{
string NewEncryptedPassword = SecurityHelper.EncryptPassword(newPassword, subscription.Salt);
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_subscriptions_pw_change_with_resetkey_update",
"@PasswordResetKey", passwordResetKey,
"@NewPassword", NewEncryptedPassword,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
}
return(result);
}
public int?AddEdit(
int?id,
int?user_id,
string username,
int?type,
string description,
DateTime?created_at,
DateTime?updated_at,
DateTime?deleted_at
)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_LogSystem_insert_update",
"@id", id,
"@user_id", user_id,
"@username", username,
"@type", type,
"@description", description,
"@created_at", created_at,
"@updated_at", updated_at,
"@deleted_at", deleted_at,
returnValue);
result = db.GetParamReturnValue(returnValue);
return(result);
}
}
public ResultDto GuarantorDetails(DataTable dt)
{
ResultDto objResult = new ResultDto();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@DataTable", dt);
parms[0].SqlDbType = System.Data.SqlDbType.Structured;
int i = Convert.ToInt16(obj.ExecNonQueryProc("uspInsertGuarantorDetails", parms));
if (i > 0)
{
objResult.ObjectCode = "TRUE";
objResult.Message = "Additional Security Details Inserted Successfullly";
objResult.ObjectId = 0;
}
else
{
objResult.ObjectCode = "FALSE";
objResult.Message = "Fail To Insert Additional Security Details";
objResult.ObjectId = 0;
}
return(objResult);
}
public int?EditProfile(string subscriptionEmail, string firstName, string lastName, DateTime?birthDate, string phoneNumber, string address, string city, string postCode, string countryCode, bool wantsNewsletter)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_subscriptions_profile_update",
"@Email", subscriptionEmail,
"@FirstName", firstName,
"@LastName", lastName,
"@BirthDate", birthDate,
"@PhoneNumber", phoneNumber,
"@Address", address,
"@City", city,
"@PostCode", postCode,
"@CountryCode", countryCode,
"@WantsNewsletter", wantsNewsletter,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
return(result);
}
public int?AddEdit(string curremtMediaGalleryCode, string newMediaGalleryCode, string languageCode, bool isActive, DateTime?publishDate, string userName, string mediaGalleryTitle)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_media_galleries_insert_update",
"@CurrentMediaGalleryCode", curremtMediaGalleryCode,
"@NewMediaGalleryCode", newMediaGalleryCode,
"@LanguageCode", languageCode,
"@IsActive", isActive,
"@PublishDate", publishDate,
"@UserName", userName,
"@MediaGalleryTitle", mediaGalleryTitle,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
return(result);
}
public int?Edit(int pageId, int?pageParentId, string segment, string pageName, string target, int?PageTemplateId, string url, bool showInMainMenu, bool showInBottomMenu, bool showInSitemap, bool isActive, bool isAccessRestricted, bool isHomePage)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_pages_update",
"@PageId", pageId,
"@PageParentId", pageParentId,
"@Segment", segment,
"@PageName", pageName,
"@Target", target,
"@PageTemplateId", PageTemplateId,
"@Url", url,
"@ShowInMainMenu", showInMainMenu,
"@ShowInBottomMenu", showInBottomMenu,
"@ShowInSitemap", showInSitemap,
"@IsActive", isActive,
"@IsAccessRestricted", isAccessRestricted,
"@IsHomePage", isHomePage,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
}
}
return(result);
}
public int?Edit(
string SiteName,
string MetaTitle,
string MetaKeywords,
string MetaDescription,
string Robots,
string NotificationEmail,
bool IsCanonicalizeActive,
string HostNameLabel,
string DomainName,
string BingVerificationCode,
string GoogleVerificationCode,
string GoogleAnalyticsTrackingCode,
string GoogleSearchCode,
bool IsOffline,
string OfflineCode,
string ServerTimeZone,
string DateFormat,
string TimeFormat,
string DefaultLanguageCode,
int DefaultErrorPageTemplateId)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_global_configuration_update",
"@SiteName", SiteName,
"@MetaTitle", MetaTitle,
"@MetaKeywords", MetaKeywords,
"@MetaDescription", MetaDescription,
"@Robots", Robots,
"@NotificationEmail", NotificationEmail,
"@IsCanonicalizeActive", IsCanonicalizeActive,
"@HostNameLabel", HostNameLabel,
"@DomainName", DomainName,
"@BingVerificationCode", BingVerificationCode,
"@GoogleVerificationCode", GoogleVerificationCode,
"@GoogleAnalyticsTrackingCode", GoogleAnalyticsTrackingCode,
"@GoogleSearchCode", GoogleSearchCode,
"@IsOffline", IsOffline,
"@OfflineCode", OfflineCode,
"@ServerTimeZone", ServerTimeZone,
"@DateFormat", DateFormat,
"@TimeFormat", TimeFormat,
"@DefaultLanguageCode", DefaultLanguageCode,
"@DefaultErrorPageTemplateId", DefaultErrorPageTemplateId,
returnValue);
result = db.GetParamReturnValue(returnValue);
if (result == 0)
{
_AllItems = GetAllItems(true);
RegisterEmailHelper();
}
}
return(result);
}
public void LockMeeting(int GroupId)
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupId", GroupId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
obj.ExecNonQueryProc("uspGroupMeetingLock", parms);
}
private void HaberSil(int v)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "delete FROM haberler0 where id=@id";
dictList.Add("@id", v.ToString());
adoHelper.ExecNonQueryProc(sorgu, dictList);
}
}
public ActionResult Sil1(int?id)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "delete FROM haberler0 where id=@id";
dictList.Add("@id", Convert.ToInt32(id));
adoHelper.ExecNonQueryProc(sorgu, dictList);
}
return(RedirectToAction("Haberlerim"));
}
public ActionResult KategoriSil(int?id)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "delete FROM kategori where id=@id";
dictList.Add("@id", id.ToString());
adoHelper.ExecNonQueryProc(sorgu, dictList);
return(RedirectToAction("KategoriListele"));
}
}
public ActionResult KategoriEkle(KategoriModel model)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "insert into kategori (kategori) Values (@kategori)";
dictList.Add("@kategori", model.Kategori);
adoHelper.ExecNonQueryProc(sorgu, dictList);
return(RedirectToAction("Index"));
}
}
public ActionResult Sil2(int?id)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "delete FROM users where id=@id";
dictList.Add("@id", id.ToString());
adoHelper.ExecNonQueryProc(sorgu, dictList);
return(RedirectToAction("KullaniciAktifPasif"));
}
}
public int DeleteKeHoachCongTac(int id)
{
const string storeName = "st_deleteKeHoach";
using (var conn = new AdoHelper())
{
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@IdKeHoach", id)
};
return(conn.ExecNonQueryProc(storeName, objectParam));
}
}
public ActionResult Aktif(int?id)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "update haberler0 set aktif=@aktif where id=@id";
dictList.Add("@aktif", 1);
dictList.Add("@id", id.ToString());
adoHelper.ExecNonQueryProc(sorgu, dictList);
return(RedirectToAction("TumHaberler"));
}
}
public ActionResult Pasif3(int?id)
{
using (AdoHelper adoHelper = new AdoHelper())
{
dictList.Clear();
string sorgu = "update users set aktif=@aktif where id=@id";
dictList.Add("@id", id.ToString());
dictList.Add("@aktif", 0);
adoHelper.ExecNonQueryProc(sorgu, dictList);
return(RedirectToAction("KullaniciAktifPasif"));
}
}
public ResultDto CreateSchedulesForOB(int LoanMasterId, decimal LoanAmount, decimal interestrate, int loanperiod, DateTime StartPaymentDate, int CurrentUserID, int PROI, string LastPaidDateOrDisbDate = null)
{
ResultDto objResult = new ResultDto();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[8];
try
{
parms[0] = new SqlParameter("@LoanAmount", LoanAmount);
parms[0].SqlDbType = System.Data.SqlDbType.Decimal;
parms[1] = new SqlParameter("@InterestRate", interestrate);
parms[1].SqlDbType = System.Data.SqlDbType.Decimal;
parms[2] = new SqlParameter("@LoanPeriod", loanperiod);
parms[2].SqlDbType = System.Data.SqlDbType.Int;
parms[3] = new SqlParameter("@StartPaymentDate", StartPaymentDate);
parms[3].SqlDbType = System.Data.SqlDbType.DateTime;
parms[4] = new SqlParameter("@LoanMasterID", LoanMasterId);
parms[4].SqlDbType = System.Data.SqlDbType.Int;
parms[5] = new SqlParameter("@UserId", CurrentUserID);
parms[5].SqlDbType = System.Data.SqlDbType.Int;
parms[6] = new SqlParameter("@PenelInterestRate", PROI);
parms[6].SqlDbType = System.Data.SqlDbType.Int;
parms[7] = new SqlParameter("@CalculationStartDate", LastPaidDateOrDisbDate);
parms[7].SqlDbType = System.Data.SqlDbType.VarChar;
int i = obj.ExecNonQueryProc("uspCreateScheduleOB", parms);
if (i > 0)
{
objResult.ObjectCode = "TRUE";
objResult.Message = "Schedule Inserted Successfullly";
objResult.ObjectId = LoanMasterId;
}
else
{
objResult.ObjectCode = "FALSE";
objResult.Message = "Fail To Insert Schedles";
objResult.ObjectId = LoanMasterId;
}
}
catch (Exception ex)
{
}
return(objResult);
}
public bool DeleteNguoiDung(string userName)
{
const string storeName = "st_DeleteNguoiDungByUserName";
using (var conn = new AdoHelper())
{
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@UserName", userName)
};
int result = conn.ExecNonQueryProc(storeName, objectParam);
return(result == 1);
}
}
public int?Delete(long?id, string username)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_TransactionLog_delete", "@Id", id, "@UserName", username, returnValue);
result = db.GetParamReturnValue(returnValue);
}
return(result);
}
public int?Delete(int?id)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_LogSystem_delete", "@Id", id, returnValue);
result = db.GetParamReturnValue(returnValue);
}
return(result);
}
public int Save(DanhBa danhBa)
{
const string storeName = "st_updateDanhBa";
using (var conn = new AdoHelper())
{
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@NoiDung", danhBa.NoiDung),
new SqlParameter("@UserName", danhBa.UserName),
new SqlParameter("@Id", danhBa.Id),
};
return(conn.ExecNonQueryProc(storeName, objectParam));
}
}
public bool ChangePassWord(string userName, string passWord, string updateBy)
{
const string storeName = "st_UpdateNguoiDungPassword";
using (var conn = new AdoHelper())
{
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@UserName", userName),
new SqlParameter("@PassWord", passWord),
new SqlParameter("@UpdateBy", updateBy)
};
int result = conn.ExecNonQueryProc(storeName, objectParam);
return(result == 1);
}
}
public int?AddEdit(int?id,
string mst,
string dvcs,
string name,
string nameEn,
string email,
string phone,
string representative,
string domain,
string address,
string serverName,
string dbName,
string dbUserName,
string dbPassword,
string dbPort,
DateTime?dateIssue,
DateTime?dateActive,
string username)
{
int?result;
using (AdoHelper db = new AdoHelper())
{
var returnValue = db.CreateParamReturnValue("returnValue");
db.ExecNonQueryProc("sp_cms_tenant_insert_update",
"@Id", id,
"@MST", mst,
"@Dvcs", dvcs,
"@Name", name,
"@NameEn", nameEn,
"@Email", email,
"@Phone", phone,
"@Representative", representative,
"@Domain", domain,
"@Address", address,
"@ServerName", serverName,
"@DbName", dbName,
"@DbUserName", dbUserName,
"@DbPassword", dbPassword,
"@DbPort", dbPort,
"@DateIssue", dateIssue,
"@DateActive", dateActive,
"@UserName", username,
returnValue);
result = db.GetParamReturnValue(returnValue);
return(result);
}
}
