public List<BizTbl_UserBusinessPartnerExt> GetTableValue()
{
DBEntities entity = new DBEntities();
DataTable dt = new DataTable();
//var Culture = new SqlParameter("@CultureCode", CultureCode);
dt.Columns.Add("id");
dt.Columns.Add("Name");
List<BizTbl_UserBusinessPartnerExt> ListOfModel = new List<BizTbl_UserBusinessPartnerExt>();
var result = entity.Database.SqlQuery<GetBusinessPartener_Result>("B_Ex_GetBusinessPartner_BizTbl_UserBusinessPartner_SP").ToList();
foreach (GetBusinessPartener_Result Val in result)
{
dt.Rows.Add(Val.id, Val.Name);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
BizTbl_UserBusinessPartnerExt HitObj = new BizTbl_UserBusinessPartnerExt();
HitObj.ID = Convert.ToInt32(dr["id"]);
HitObj.Name = dr["Name"].ToString();
ListOfModel.Add(HitObj);
}
}
return ListOfModel;
}
public List<HitcountExt> GetHitCountTableValue()
{
DBEntities entity = new DBEntities();
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Part");
dt.Columns.Add("RecordID");
dt.Columns.Add("HitCount");
dt.Columns.Add("Description");
dt.Columns.Add("Date");
var result = entity.Database.SqlQuery<GetHitCountDetails_Result>("B_Ex_GetHitTableValue_TB_HitCount_SP").ToList();
List<HitcountExt> ListOfModel = new List<HitcountExt>();
foreach (GetHitCountDetails_Result Val in result)
{
dt.Rows.Add(Val.ID, Val.PartIDName, Val.RecordID, Val.HitCount, Val.Description, Val.Date);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
HitcountExt HitObj = new HitcountExt();
HitObj.ID = Convert.ToInt32(dr["ID"]);
HitObj.Part = dr["Part"].ToString();
HitObj.RecordID = dr["RecordID"].ToString();
HitObj.HitCount = Convert.ToInt32(dr["HitCount"]);
HitObj.Description = dr["Description"].ToString();
HitObj.Date = Convert.ToDateTime(dr["Date"]);
ListOfModel.Add(HitObj);
}
}
return ListOfModel;
}
private bool ValidateToken(string key, out string userId)
{
try
{
bool isTest;
bool isSecret;
var token = ParseToken(key, out isTest, out isSecret);
using (var db = new DBEntities())
{
if (isSecret)
{
userId = db.SecretKeys.Where(k => k.Value == token && k.IsTest == isTest && !k.IsRevoked).Select(k => k.UserId).First();
}
else
{
userId = db.PublishableKeys.Where(pk => pk.Value == token && pk.IsTest == isTest && !pk.IsRevoked).Select(pk => pk.UserId).First();
}
}
return true;
}
catch (Exception ex)
{
userId = string.Empty;
return false;
}
}
public List<HitcountExt> GetPartTableValue()
{
DBEntities entity = new DBEntities();
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
List<HitcountExt> ListOfModel = new List<HitcountExt>();
var result = entity.Database.SqlQuery<GetPart_Result>("B_Ex_GetPart_TB_Part_SP").ToList();
foreach (GetPart_Result Val in result)
{
dt.Rows.Add(Val.ID, Val.Name);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
HitcountExt HitObj = new HitcountExt();
HitObj.ID = Convert.ToInt32(dr["ID"]);
HitObj.Name = dr["Name"].ToString();
ListOfModel.Add(HitObj);
}
}
return ListOfModel;
}
public static byte[] GetFile(string token)
{
var data = new byte[0];
var id = new Guid(token);
using (var context = new DBEntities(Settings.ConnectionString))
{
var file = context.UploadedFiles.FirstOrDefault(f => f.Id == id);
if (file != null)
{
data = file.Data;
}
}
return data;
}
public bool Create(Biztbl_PageExt model, ref string Msg, Controller ctrl)
{
bool status = true;
DBEntities insertentity = new DBEntities();
BizTbl_Page MsgObj = new BizTbl_Page();
MsgObj.ID = model.ID;
//MsgObj.MailTemplateID = model.MailTemplateID;
MsgObj.Code = model.Code;
MsgObj.Description_en = model.Description;
MsgObj.Title_en = model.Title;
MsgObj.OpDateTime = DateTime.Now;
MsgObj.OpUserID = 0;
insertentity.BizTbl_Page.Add(MsgObj);
insertentity.SaveChanges();
return status;
}
public static string GeneratePublishableKey(string userId, bool isTest)
{
var newKey = GenerateRandomKey();
var secretKey = new PublishableKey
{
UserId = userId,
CreatedDate = DateTime.UtcNow,
IsTest = isTest,
Value = newKey
};
using (var db = new DBEntities())
{
db.PublishableKeys.Add(secretKey);
db.SaveChanges();
}
return FormatTHeKey("pk_", isTest, newKey);
}
public ActionResult Delete(string token)
{
var id = new Guid(token);
using (var context = new DBEntities(Settings.ConnectionString))
{
var file = context.UploadedFiles.FirstOrDefault(f => f.Id == id);
if (file != null)
{
context.UploadedFiles.DeleteObject(file);
context.SaveChanges();
}
}
return new ContentResult
{
ContentType = "text/html",
Content = "{success:true}"
};
}
private static void AddNewSecretKey(string key, string userId, bool isTestMode)
{
var secretKey = new SecretKey
{
UserId = userId,
CreatedDate = DateTime.UtcNow,
IsTest = isTestMode,
Value = key
};
using (var db = new DBEntities())
{
var activeSecret = db.SecretKeys.Where(sk => sk.UserId == userId && !sk.IsRevoked && sk.IsTest == isTestMode).FirstOrDefault();
if (activeSecret != null)
{
activeSecret.IsRevoked = true;
activeSecret.RevokedDate = DateTime.UtcNow;
}
db.SecretKeys.Add(secretKey);
db.SaveChanges();
}
}
private static void AddNewPublishableKey(string key, string userId, bool isTestMode)
{
var publishableKey = new PublishableKey
{
UserId = userId,
CreatedDate = DateTime.UtcNow,
IsTest = isTestMode,
Value = key
};
using (var db = new DBEntities())
{
var activePublishableKey = db.PublishableKeys.Where(pk => pk.UserId == userId && !pk.IsRevoked && pk.IsTest == isTestMode).FirstOrDefault();
if (activePublishableKey != null)
{
activePublishableKey.IsRevoked = true;
activePublishableKey.RevokedDate = DateTime.UtcNow;
}
db.PublishableKeys.Add(publishableKey);
db.SaveChanges();
}
}
public List<BizTbl_ErrorExt> ReadAll(int TableID)
{
List<BizTbl_ErrorExt> list = new List<BizTbl_ErrorExt>();
DBEntities entity = new DBEntities();
var TableIDparam = new SqlParameter("@TableID", TableID);
var Cultureparam = new SqlParameter("@CultureCode", CultureCode);
var result = entity.Database.SqlQuery<BizTbl_Error>("B_DisplayTable_BizTbl_Table_Sp @TableID,@CultureCode", TableIDparam, Cultureparam).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Page");
dt.Columns.Add("Message");
dt.Columns.Add("Detail");
dt.Columns.Add("Date");
dt.Columns.Add("IPAddress");
foreach (BizTbl_Error dr in result)
{
dt.Rows.Add(dr.ID, dr.Page, dr.Message, dr.Detail, dr.Date, dr.IPAddress);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
BizTbl_ErrorExt model = new BizTbl_ErrorExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.Page = dr["Page"].ToString();
model.Message = dr["Message"].ToString();
model.Detail = dr["Detail"].ToString();
model.Date = Convert.ToDateTime(dr["Date"]);
model.IPAddress = dr["IPAddress"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 开通或设置医生服务（支持单项服务设置）
/// </summary>
/// <param name="list">服务列表</param>
/// <param name="doctorID">医生</param>
/// <returns></returns>
public EnumApiStatus DoctorServiceSettings(List <RequestDoctorServiceSettingDTO> list, string doctorID)
{
var result = EnumApiStatus.BizError;
using (var db = new DBEntities())
{
var serviceList = db.DoctorServices.Where(i => i.DoctorID == doctorID).ToList();
list.ForEach(model =>
{
#region 添加或修改服务
var entity = serviceList.Where(i => i.ServiceType == model.ServiceType).FirstOrDefault();
if (entity == null)
{
entity = new Entity.DoctorService()
{
DoctorID = doctorID,
ServiceType = model.ServiceType,
ServicePrice = model.ServicePrice,
ServiceSwitch = model.ServiceSwitch == 1 ? true : false,
};
PreInsert(db, entity);
serviceList.Add(entity);
}
else
{
entity.IsDeleted = false;
entity.ServicePrice = model.ServicePrice;
entity.ServiceSwitch = model.ServiceSwitch == 1 ? true : false;
}
#endregion
});
#region 图文咨询、语音咨询和视频咨询都是开启状态，才能手动开启家族服务
var familyModel = list.Where(i => i.ServiceType == EnumDoctorServiceType.FamilyDoctor && i.ServiceSwitch == 1).FirstOrDefault();
if (familyModel != null)
{
if (serviceList.Count(i =>
(i.ServiceType == EnumDoctorServiceType.PicServiceType ||
i.ServiceType == EnumDoctorServiceType.AudServiceType ||
i.ServiceType == EnumDoctorServiceType.VidServiceType) &&
i.ServiceSwitch == true && i.IsDeleted == false) < 3)
{
return(EnumApiStatus.BizDoctorServiceNotOpenFamilyDoctorService);
}
}
#endregion
#region 如果图文咨询、语音、视频咨询没有开启，那么家庭医生需要关闭
var isClose = serviceList.Where(i =>
(i.ServiceType == EnumDoctorServiceType.PicServiceType ||
i.ServiceType == EnumDoctorServiceType.AudServiceType ||
i.ServiceType == EnumDoctorServiceType.VidServiceType) &&
i.ServiceSwitch == false && i.IsDeleted == false).FirstOrDefault() != null ? true : false;
if (isClose == true)
{
var familyEntity = serviceList.Where(i => i.ServiceType == EnumDoctorServiceType.FamilyDoctor && i.IsDeleted == false && i.ServiceSwitch == true).FirstOrDefault();
if (familyEntity != null)
{
familyEntity.ServiceSwitch = false;
}
}
#endregion
//result = db.SaveChanges() > 0 ? EnumApiStatus.BizOK : EnumApiStatus.BizError;
var res = db.SaveChanges();
result = EnumApiStatus.BizOK;
//清缓存
if (result == EnumApiStatus.BizOK)
{
var CacheKey = new EntityListCacheKey <ResponseDoctorServicePriceDTO>(StringCacheKeyType.Doctor_ServicePrice, doctorID);
CacheKey.RemoveCache();
var DoctorServiceSetting_CacheKey = new EntityCacheKey <ResponseDoctorServicePriceDTO>(StringCacheKeyType.Doctor_ServicePrice, doctorID);
DoctorServiceSetting_CacheKey.RemoveCache();
}
}
return(result);
}
public ActionResult AddNote(Note model, FormCollection collection)
{
bool isPaid = false;
if (collection["sell-for"] == "paid")
{
isPaid = true;
}
User loggedInUser = (User)Session["user"];
using (var context = new DBEntities())
{
Models.Extended.SellerNote newNote = model.sellerNote;
Models.SellerNote note1 = new Models.SellerNote()
{
SellerID = loggedInUser.ID,
Title = newNote.Title,
Status = 7,
Category = newNote.Category,
NoteType = newNote.NoteType,
NumberOfPages = newNote.NumberOfPages,
Description = newNote.Description,
Country = newNote.Country,
UniversityName = newNote.UniversityName,
Course = newNote.Course,
CourseCode = newNote.CourseCode,
Professor = newNote.Professor,
IsPaid = isPaid,
SellingPrice = newNote.SellingPrice,
IsActive = true,
CreatedDate = DateTime.Now,
CreatedBy = loggedInUser.ID,
ModifiedDate = DateTime.Now,
ModifiedBy = loggedInUser.ID
};
context.SellerNotes.Add(note1);
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
string previewPath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID);
if (!Directory.Exists(previewPath))
{
Directory.CreateDirectory(previewPath);
}
string previewFileName = "Preview_" + DateTime.Now.ToString("dd/MM/yyyy") + ".pdf";
string fullPreviewFilePath = Path.Combine(previewPath, previewFileName);
string relativePreviewFilePath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID, previewFileName);
model.sellerNote.NotesPreview.SaveAs(fullPreviewFilePath);
var fNote = context.SellerNotes.FirstOrDefault(x => x.ID == note1.ID);
fNote.NotesPreview = relativePreviewFilePath;
string displayPicPath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID);
string displayPicName = "DisplayPicture" + DateTime.Now.ToString("dd/MM/yyyy") + ".jpg";
string fulldisplayPicPath = Path.Combine(displayPicPath, displayPicName);
string relativeDisplayPicPath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID, displayPicName);
model.sellerNotesAttachment.FilePath.SaveAs(fulldisplayPicPath);
fNote.DisplayPicture = relativeDisplayPicPath;
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
string filePath = Server.MapPath("~/Members/" + note1.SellerID + "/" + note1.ID + "/Attachments");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string fileName = "Attachment_" + DateTime.Now.ToString("dd/MM/yyyy") + ".pdf";
string fullFilePath = Path.Combine(filePath, fileName);
string relativeFilePath = Path.Combine("~/Members/" + note1.SellerID + "/" + note1.ID + "/Attachments", fileName);
model.sellerNotesAttachment.FilePath.SaveAs(fullFilePath);
var requiredNoteId = context.SellerNotes.Max(x => x.ID);
Models.SellerNotesAttachment notesAttachment = new Models.SellerNotesAttachment()
{
NoteID = requiredNoteId,
FileName = fileName,
FilePath = relativeFilePath,
CreatedDate = DateTime.Now,
CreatedBy = note1.SellerID,
ModifiedDate = DateTime.Now,
ModifiedBy = note1.SellerID,
IsActive = true
};
context.SellerNotesAttachments.Add(notesAttachment);
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
return(View());
}
public ApiController(DBEntities context)
{
_context = context;
}
/// <summary>
/// 获取房间用户信息
/// </summary>
/// <param name="ConversationRoomID"></param>
/// <returns></returns>
public List <ResponseConversationRoomMemberDTO> GetChannelUsersInfo(string ConversationRoomID, DBEntities db = null)
{
var cacheKey = new StringCacheKey(StringCacheKeyType.Channel_Member, ConversationRoomID);
var result = cacheKey.FromCache <List <ResponseConversationRoomMemberDTO> >();
if (result == null)
{
bool dbPrivateFlag = false;
if (db == null)
{
db = CreateDb();
dbPrivateFlag = true;
}
result = (
from roomMember in db.ConversationRoomUids
join room in db.ConversationRooms on roomMember.ConversationRoomID equals room.ConversationRoomID
where room.ConversationRoomID == ConversationRoomID
select new ResponseConversationRoomMemberDTO
{
identifier = roomMember.Identifier,
UserCNName = roomMember.UserCNName,
UserENName = roomMember.UserENName,
PhotoUrl = roomMember.PhotoUrl,
UserType = roomMember.UserType,
UserID = roomMember.UserID,
}).ToList();
if (dbPrivateFlag)
{
db.Dispose();
}
result.ToCache(cacheKey, TimeSpan.FromHours(2));
}
return(result);
}
public string InsertEmail(string Template, string MailFrom, string MailTo, string ResentCount, string SendingDate, string Subject, string Content, string MailCC, string SentStatus, string Record,Controller Ctrl)
{
string status = "Success";
DBEntities insertentity = new DBEntities();
BizTbl_MailQueue MsgObj = new BizTbl_MailQueue();
MsgObj.MailTemplateID = Convert.ToInt32(Template);
MsgObj.MailFrom = MailFrom;
MsgObj.MailTo = MailTo;
MsgObj.MailCC = MailCC;
MsgObj.Subject = Subject;
MsgObj.Body = Content;
MsgObj.IsSent = Convert.ToBoolean(SentStatus);
if (ResentCount == "")
{
MsgObj.ResentCount = 0;
}
else
{
MsgObj.ResentCount = Convert.ToInt32(ResentCount);
}
MsgObj.SendingDateTime = DateTime.Now;
if (Record == "")
{
MsgObj.RecordID = null;
}
else
{
MsgObj.RecordID = Convert.ToInt64(Record);
}
MsgObj.OpDateTime = DateTime.Now;
MsgObj.OpUserID = Convert.ToInt64(Ctrl.Session["UserID"]);
insertentity.BizTbl_MailQueue.Add(MsgObj);
insertentity.SaveChanges();
return status;
}
//--------------------------------------------------------- edit data candidate -------------------------------------------------
public static int EditCandidate(CandidateDTO Data, HttpPostedFileBase Pict, HttpPostedFileBase Cv)
{
using (DBEntities db = new DBEntities())
{
TB_CANDIDATE Candidate = db.TB_CANDIDATE.FirstOrDefault(d => d.ID == Data.ID);
//process file pict candidate
string pict_name = "-";
if (Pict != null)
{
string pict_ext = Pict.FileName.Split('.')[1];
pict_name = "Pict_" + DateTime.Now.ToString("ffff") + "." + pict_ext;
string path_pict = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Pict/"), pict_name);
Pict.SaveAs(path_pict);
}
//process file Cv
string Cv_name = "-";
if (Cv != null)
{
string Cv_ext = Cv.FileName.Split('.')[1];
Cv_name = "Cv_" + DateTime.Now.ToString("ffff") + "." + Cv_ext;
string path_cv = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Cv/"), Cv_name);
Cv.SaveAs(path_cv);
}
//process to convert datetime
var birth_date = Convert.ToDateTime(Data.CANDIDATE_BIRTH_DATE);
var edu_start_date = Convert.ToDateTime(Data.EDUCATON_START_DATE);
var edu_end_date = Convert.ToDateTime(Data.EDUCATON_END_DATE);
//add selection history
if (Candidate.CANDIDATE_STATE_ID != Data.CANDIDATE_STATE_ID)
{
//insert selection history
UserDTO UserLogin = (UserDTO)HttpContext.Current.Session["UserLogin"];
db.TB_CANDIDATE_SELECTION_HISTORY.Add(new TB_CANDIDATE_SELECTION_HISTORY
{
CANDIDATE_ID = Data.ID,
PIC_ID = UserLogin.USER_ID,
CANDIDATE_APPLIED_POSITION = Data.POSITION,
CANDIDATE_SUITABLE_POSITION = Data.SUITABLE_POSITION,
CANDIDATE_SOURCE = Data.SOURCE,
CANDIDATE_EXPECTED_SALARY = Data.EXPECTED_sALARY,
CANDIDATE_STATE = Data.CANDIDATE_STATE_ID,
NOTES = Data.NOTES,
PROCESS_DATE = DateTime.Now,
CANDIDATE_INTERVIEW_DATE = Data.CANDIDATE_INTERVIEW_DATE
});
db.SaveChanges();
}
//process update data
Candidate.CANDIDATE_NAME = Data.CANDIDATE_NAME;
Candidate.CANDIDATE_AGE = Data.CANDIDATE_AGE;
Candidate.CANDIDATE_BIRTH_DATE = birth_date;
Candidate.CANDIDATE_PLACE_BIRTH = Data.CANDIDATE_PLACE_BIRTH;
Candidate.MARITAL_STATUS_ID = Data.MARITAL_STATUS_ID;
Candidate.GENDER_ID = Data.GENDER_ID;
Candidate.RELIGION_ID = Data.RELIGION_ID;
Candidate.CANDIDATE_ETNIC = Data.CANDIDATE_ETNIC;
Candidate.CANDIDATE_HOMENUMBER = Data.CANDIDATE_HOMENUMBER;
Candidate.CANDIDATE_PHONENUMBER = Data.CANDIDATE_PHONENUMBER;
Candidate.CANDIDATE_EMAIL = Data.CANDIDATE_EMAIL;
Candidate.CANDIDATE_CITY = Data.CANDIDATE_CITY;
Candidate.CANDIDATE_PROVINCE = Data.CANDIDATE_PROVINCE;
Candidate.CANDIDATE_CURRENT_ADDRESS = Data.CANDIDATE_CURRENT_ADDRESS;
Candidate.CANDIDATE_KTP_NUMBER = Data.CANDIDATE_KTP_NUMBER;
Candidate.CANDDIATE_NPWP_NUMBER = Data.CANDDIATE_NPWP_NUMBER;
if (Cv != null)
{
Candidate.CANDIDATE_CV = Cv_name;
}
if (Pict != null)
{
Candidate.CANDIDATE_PHOTO = pict_name;
}
Candidate.CANDIDATE_LAST_EDUCATON = Data.CANDIDATE_LAST_EDUCATON;
Candidate.CANDIDATE_GPA = Data.CANDIDATE_GPA;
Candidate.CANDIDATE_MAJOR = Data.CANDIDATE_MAJOR;
Candidate.CANDIDATE_DEGREE = Data.CANDIDATE_DEGREE;
Candidate.CANDIDATE_STATE_ID = Data.CANDIDATE_STATE_ID;
Candidate.SOURCE = Data.SOURCE;
Candidate.SOURCING_DATE = DateTime.Now;
Candidate.ZIP_CODE = Data.ZIP_CODE;
Candidate.PARENT_ADDRESS = Data.PARENT_ADDRESS;
Candidate.RESIDENT_CARD_NUMBER = Data.RESIDENT_CARD_NUMBER;
Candidate.TELEPHONE_NUMBER = Data.TELEPHONE_NUMBER;
Candidate.AVAILABLE_JOIN = Data.AVAILABLE_JOIN;
Candidate.RECOMENDATION = Data.RECOMENDATION;
Candidate.EXPECTED_SALARY = Data.EXPECTED_sALARY;
Candidate.NOTES = Data.NOTES;
Candidate.POSITION = Data.POSITION;
Candidate.SUITABLE_POSITION = Data.SUITABLE_POSITION;
Candidate.EDUCATION_START_DATE = edu_start_date;
Candidate.EDUCATION_END_DATE = edu_end_date;
Candidate.CANDIDATE_INTERVIEW_DATE = Data.CANDIDATE_INTERVIEW_DATE;
List <string> Skills = db.TB_CANDIDATE_SKILL.Where(d => d.CANDIDATE_ID == Data.ID).Select(d => d.SKILL).ToList();
if (Skills.Count > 0)
{
foreach (var d in db.TB_CANDIDATE_SKILL.Where(d => d.CANDIDATE_ID == Data.ID).ToList())
{
db.TB_CANDIDATE_SKILL.Remove(d);
}
}
foreach (var d in Data.CANDIDATE_SKILL)
{
db.TB_CANDIDATE_SKILL.Add(new TB_CANDIDATE_SKILL {
CANDIDATE_ID = Data.ID,
SKILL = d
});
}
return(db.SaveChanges());
}
}
private void Validate(DBEntities context, MetaSchedulerModel model)
{
if (model.TypeId == 0 && model.PeriodId.HasValue)
{
if (model.PeriodId.Value > 0 && !model.StartTime2.HasValue)
{
ModelState.AddModelError("StartTime2", "Поле обязательно для заполения!");
}
if (model.PeriodId.Value > 1 && !model.NumberInPeriod.HasValue)
{
ModelState.AddModelError("NumberInPeriod", "Поле обязательно для заполения!");
}
}
if (model.TypeId == 1 && !model.IntervalSecond.HasValue)
{
ModelState.AddModelError("IntervalSecond", "Поле обязательно для заполения!");
}
}
public bool Update(CountryExt model, ref string Msg, Controller ctrl)
{
bool status = true;
using (DBEntities DE = new DBEntities())
{
var MessageTable = DE.TB_Country.Where(x => x.ID == model.ID).FirstOrDefault();
MessageTable.CurrencyID = model.CurrencyID;
MessageTable.Name_en = model.Name;
MessageTable.Code = model.Code;
MessageTable.CultureCode = model.CultureCode;
MessageTable.VAT = Convert.ToInt32(model.VAT);
MessageTable.HasCityTax = model.CityTax;
MessageTable.HitCount = model.HitCount;
MessageTable.Sort = model.Sort;
MessageTable.Active = model.Active;
MessageTable.TempCode = Convert.ToInt32(model.TemparoryCode);
DE.SaveChanges();
}
return status;
}
public async Task <ActionResult> Create(ProjectsVm data)
{
using (_entities = new DBEntities())
{
var userMasterId = Convert.ToInt64(CookieHelper.GetCookie(CookieName.UserMasterId));
if (data.ProjectId > 0)
{
//Update Code HERE
var project = new Project();
project = await _entities.Projects.FindAsync(data.ProjectId);
if (project != null)
{
project.BasicDescription = data.BasicDescription;
project.Budget = data.Budget;
project.ClientName = data.ClientName;
project.ConfidentialDescription = data.ConfidentialDescription;
project.EstimateHours = data.EstimateHours;
project.LiveURL = data.LiveURL;
project.Name = data.Name;
project.ClientName = data.ClientName;
project.TagLine = data.TagLine;
project.TeamMemberCount = data.TeamMemberCount;
project.UpdatedBy = userMasterId;
project.UpdatedDate = DateTime.Now;
project.StartDate = DateTime.ParseExact(data.StartDateString,
data.StartDateString.Contains('-') ? "dd-MM-yyyy" : "dd/MM/yyyy",
CultureInfo.InvariantCulture);
if (!string.IsNullOrWhiteSpace(data.EndDateString))
{
project.EndDate = DateTime.ParseExact(data.EndDateString,
data.EndDateString.Contains('-') ? "dd-MM-yyyy" : "dd/MM/yyyy",
CultureInfo.InvariantCulture);
}
_entities.Entry(project).State = EntityState.Modified;
await _entities.SaveChangesAsync();
//Delete Existing Assigny and Add new Assigny and Save assigny list HERE
if (data.AssignyList.Any())
{
var projectAssignys = await _entities.ProjectAssignies
.Where(s => s.ProjectId == data.ProjectId).ToListAsync();
if (projectAssignys.Any())
{
_entities.ProjectAssignies.RemoveRange(projectAssignys);
await _entities.SaveChangesAsync();
}
projectAssignys = new List <ProjectAssigny>();
projectAssignys = data.AssignyList.Select(item => new ProjectAssigny
{
ProjectId = project.ProjectId,
AssignyId = Convert.ToInt64(item),
CreatedBy = userMasterId,
CreatedDate = DateTime.Now,
WhoAssign = userMasterId
}).ToList();
_entities.ProjectAssignies.AddRange(projectAssignys);
await _entities.SaveChangesAsync();
}
//Delete existing attachment and Save new attachment
if (data.AttachedFiles != null && data.AttachedFiles.Any())
{
var projectAttachments = await _entities.ProjectAttachments
.Where(s => s.ProjectId == data.ProjectId).ToListAsync();
if (projectAttachments.Any())
{
_entities.ProjectAttachments.RemoveRange(projectAttachments);
await _entities.SaveChangesAsync();
}
projectAttachments = (from item in data.AttachedFiles
where item != null
select new ProjectAttachment
{
ProjectId = project.ProjectId,
CreatedBy = userMasterId,
CreatedDate = DateTime.Now,
DisplayName = item.FileName,
FileName = Utilities.SaveFile(item,
Server.MapPath("~" + BasicProperty.ProjectAttachmentPath + project.ProjectId +
"/"), Guid.NewGuid().ToString()),
FileSize = item.ContentLength / 1024
}).ToList();
if (projectAttachments.Any())
{
_entities.ProjectAttachments.AddRange(projectAttachments);
}
}
TempData["Success"] = "Project updated successfully";
}
else
{
TempData["Error"] = "Request failed! Please try after some time.";
}
}
else
{
//Save data in project table
var project = new Project();
project.CopyProperties(data);
project.ProjectStatusMasterId = data.ProjectStatusMasterId;
project.IsActive = true;
project.IsDelete = false;
project.CreatedBy = userMasterId;
project.CreatedDate = DateTime.Now;
project.StartDate = DateTime.ParseExact(data.StartDateString,
data.StartDateString.Contains('-') ? "dd-MM-yyyy" : "dd/MM/yyyy", CultureInfo.InvariantCulture);
if (!string.IsNullOrWhiteSpace(data.EndDateString))
{
project.EndDate = DateTime.ParseExact(data.EndDateString,
data.EndDateString.Contains('-') ? "dd-MM-yyyy" : "dd/MM/yyyy",
CultureInfo.InvariantCulture);
}
_entities.Projects.Add(project);
await _entities.SaveChangesAsync();
// Save assigny list HERE
if (data.AssignyList.Any())
{
var projectAssignys = data.AssignyList.Select(item => new ProjectAssigny
{
ProjectId = project.ProjectId,
AssignyId = Convert.ToInt64(item),
CreatedBy = userMasterId,
CreatedDate = DateTime.Now,
WhoAssign = userMasterId
}).ToList();
_entities.ProjectAssignies.AddRange(projectAssignys);
await _entities.SaveChangesAsync();
}
//Save attachment
if (data.AttachedFiles != null && data.AttachedFiles.Any())
{
var projectAttachments = (from item in data.AttachedFiles
where item != null
select new ProjectAttachment
{
ProjectId = project.ProjectId,
CreatedBy = userMasterId,
CreatedDate = DateTime.Now,
DisplayName = item.FileName,
FileName = Utilities.SaveFile(item,
Server.MapPath("~" + BasicProperty.ProjectAttachmentPath + project.ProjectId + "/"),
Guid.NewGuid().ToString()),
FileSize = item.ContentLength / 1024
}).ToList();
if (projectAttachments.Any())
{
_entities.ProjectAttachments.AddRange(projectAttachments);
}
}
//Save call
await _entities.SaveChangesAsync();
TempData["Success"] = "Projece added successfully";
}
}
return(RedirectToAction("List"));
}
public UserController()
{
db = new DBEntities();
}
private void SyncReportItems(MetaReport target, List<MetaReportItemModel> itemModel, DBEntities context)
{
MetaReportItemModel.CreateMap();
var reportItems = context.MetaReportItem.Where(c => c.MetaReportId == target.Id).ToList();
foreach (var item in itemModel)
{
var reportItem = reportItems.FirstOrDefault(c => c.Id == item.Id);
if (reportItem == null)
{
reportItem = new MetaReportItem()
{
Id = item.Id
};
Mapper.Map(item, reportItem);
reportItem.MetaReportId = target.Id;
context.MetaReportItem.AddObject(reportItem);
}
else
{
Mapper.Map(item, reportItem);
reportItem.MetaReportId = target.Id;
}
}
for (int i = 0; i < reportItems.Count; i++)
{
var reportItem = reportItems[i];
var item = itemModel.FirstOrDefault(c => c.Id == reportItem.Id);
if (item == null)
{
context.MetaReportItem.DeleteObject(reportItems[i]);
reportItems.RemoveAt(i);
i--;
}
}
}
public string Post([FromBody] JObject jObj)
{
DBEntities db = new DBEntities();
List <usr> uData = db.usr.ToList();
List <course> cData = db.course.ToList();
List <uc> ucData = db.uc.ToList();
string type = jObj["type"].ToString(); //客户端操作类型
if (type.Equals("login"))
{
string inNo = jObj["no"].ToString();
string inPw = jObj["pw"].ToString();
//匹配成功,返回users的id,密码错误返回-1， 账号不存在返回0
for (int i = 0; i < uData.Count; i++)
{
if (uData[i].no == inNo)
{
if (uData[i].pw == inPw)
{
return(uData[i].uid.ToString());
}
else
{
return("-1");
}
}
}
return("0");
}
else if (type.Equals("register"))
{
string no = jObj["no"].ToString();
string pw = jObj["pw"].ToString();
string school = jObj["school"].ToString();
string major = jObj["major"].ToString();
usr uTmp = db.usr.Where(usr => usr.no == no).FirstOrDefault();
if (uTmp == null)
{
usr u = new usr()
{
no = no, pw = pw, school = school, major = major
};
db.usr.Add(u);
if (db.SaveChanges() > 0)
{
return("1");
}
return("-1");
}
else
{
return("0");
}
}
else if (type.Equals("getCourseInfo"))
{
int uid = int.Parse(jObj["uid"].ToString()); //得到客户端当前登录用户的id
List <course> cUidData = new List <course>(); //储存匹配到的当前用户的课程信息
for (int i = 0; i < ucData.Count; i++)
{
if (ucData[i].uid == uid)
{
for (int j = 0; j < cData.Count; j++)
{
if (cData[j].cid == ucData[i].cid)
{
course c = new course(); //一条课程记录
c.cid = cData[j].cid;
c.coursename = cData[j].coursename;
c.teacher = cData[j].teacher;
c.classroom = cData[j].classroom;
c.classstart = cData[j].classstart;
c.classend = cData[j].classend;
c.day = cData[j].day;
cUidData.Add(c);
}
}
}
}
return(JsonConvert.SerializeObject(cUidData));
}
else if (type.Equals("addCourse") || type.Equals("editCourse") || type.Equals("delCourse"))
{
int uid = int.Parse(jObj["uid"].ToString()); //得到当前用户的id
int cid = int.Parse(jObj["cid"].ToString()); //得到课程id,若type为edit则为修改前的id，若为del则为要删除的id, 若为add则为0（防止空指针异常）
if (type.Equals("delCourse")) //删除操作
{
uc ucTmp = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault();
db.uc.Remove(ucTmp);
}
else
{
//得到修改后的课程
string cn = jObj["coursename"].ToString();
string tn = jObj["teacher"].ToString();
string cr = jObj["classroom"].ToString();
int cs = int.Parse(jObj["classstart"].ToString());
int ce = int.Parse(jObj["classend"].ToString());
int day = int.Parse(jObj["day"].ToString());
if (type.Equals("addCourse")) //若添加的课程与已存在的课程时间段有重合，则添加失败
{
List <course> cSEList = db.course.Where(course => course.classstart >= cs && course.classend <= ce && course.day == day).ToList();
List <uc> ucUidList = db.uc.Where(uc => uc.uid == uid).ToList();
for (int i = 0; i < cSEList.Count; i++)
{
for (int j = 0; j < ucUidList.Count; j++)
{
if (cSEList[i].cid == ucUidList[j].cid)
{
return("0");
}
}
}
}
course cTmp1 = db.course.Where(course => course.coursename == cn &&
course.teacher == tn &&
course.classroom == cr &&
course.classstart == cs &&
course.classend == ce &&
course.day == day
).FirstOrDefault();
course c = new course();
course cTmp2 = new course();
if (cTmp1 == null)
{
cTmp2.coursename = cn;
cTmp2.teacher = tn;
cTmp2.classroom = cr;
cTmp2.classstart = cs;
cTmp2.classend = ce;
cTmp2.day = day;
db.course.Add(cTmp2);
db.SaveChanges();
c = cTmp2;
}
else
{
c = cTmp1;
}
if (type.Equals("addCourse")) //添加操作
{
uc ucTmp = new uc()
{
uid = uid, cid = c.cid
};
db.uc.Add(ucTmp);
}
else if (type.Equals("editCourse")) //编辑操作
{
uc ucUid = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault();
ucUid.cid = c.cid;
}
cid = c.cid; //便于返回cid
}
if (db.SaveChanges() > 0)
{
return(cid.ToString());
}
return("0");
}
return("0");
}
public void Build(int ApplicationId, string menuPath, bool forceRebuild)
{
try
{
// INIT
core = COREobject.i;
masterContext = core.Context;
core.Application = masterContext.Applications.Find(ApplicationId);
masterApp = core.Application;
context = core.AppContext;
app = context != masterContext
? context.Applications.SingleOrDefault(a => a.Name == masterApp.Name)
: masterApp;
_rebuildInAction = forceRebuild;
_menuPath = menuPath;
applicationViewPath = $"{AppDomain.CurrentDomain.BaseDirectory}Views\\App\\{app.Name}";
applicationPageViewPath = $"{applicationViewPath}\\Page";
// Shared tables
if (masterApp.IsSystem)
{
progressHandler.Section(EModule.Entitron, "Actualize database");
BuildEntitron();
return;
}
// FrontEnd
progressHandler.Section(EModule.Master, "Copy application");
progressHandler.Section(EModule.Persona, "Copy user roles");
progressHandler.Section(EModule.Entitron, "Actualize database");
progressHandler.Section(EModule.Mozaic, "Generate pages");
progressHandler.Section(EModule.Tapestry, "Generate workflow");
progressHandler.Section(EModule.CORE, "Generate menu");
progressHandler.Section(EModule.Hermes, "Copy email template");
MoveApp();
BuildPersona();
BuildEntitron();
BuildMozaic();
BuildTapestry();
BuildTapestry2();
BuildMenu();
BuildHermes();
progressHandler.Section(EModule.Watchtower, "All DONE");
}
catch (OmniusMultipleException ex)
{
if (!ex.AllExceptions.Any())
{
progressHandler.Error("Unknown error");
}
foreach (Exception e in ex.AllExceptions)
{
progressHandler.Error(e.Message);
}
}
catch (Exception ex)
{
progressHandler.Error(ex.Message);
}
}
public List<TB_LatestNewsExt> ReadAll(int TableID)
{
List<TB_LatestNewsExt> list = new List<TB_LatestNewsExt>();
DBEntities entity = new DBEntities();
var TableIDparam = new SqlParameter("@TableID", TableID);
var Cultureparam = new SqlParameter("@CultureCode", CultureCode);
var result = entity.Database.SqlQuery<TB_LatestNews>("B_DisplayTableNew_BizTbl_Table_Sp @TableID,@CultureCode", TableIDparam, Cultureparam).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("UserID");
dt.Columns.Add("Title_tr");
dt.Columns.Add("Title_en");
dt.Columns.Add("Title_de");
dt.Columns.Add("Title_fr");
dt.Columns.Add("Title_ru");
dt.Columns.Add("Title_ar");
dt.Columns.Add("Description_tr");
dt.Columns.Add("Description_en");
dt.Columns.Add("Description_de");
dt.Columns.Add("Description_fr");
dt.Columns.Add("Description_ru");
dt.Columns.Add("Description_ar");
dt.Columns.Add("PostImage");
dt.Columns.Add("Travel");
dt.Columns.Add("Active");
dt.Columns.Add("Createddate");
foreach (TB_LatestNews dr in result)
{
dt.Rows.Add(dr.ID, dr.UserID, dr.Title_tr, dr.Title_en, dr.Title_de, dr.Title_fr, dr.Title_ru, dr.Title_ar,dr.Description_tr,dr.Description_en,dr.Description_de,
dr.Description_fr,dr.Description_ru,dr.Description_ar,dr.PostImage,dr.Travel,dr.Active,dr.Createddate);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TB_LatestNewsExt model = new TB_LatestNewsExt();
model.ID = Convert.ToInt32(dr["ID"]);
model.UserID = Convert.ToInt32(dr["UserID"]);
model.Title_tr = dr["Title_tr"].ToString();
model.Title_en = dr["Title_en"].ToString();
model.Title_de = dr["Title_de"].ToString();
model.Title_fr = dr["Title_fr"].ToString();
model.Title_ru = dr["Title_ru"].ToString();
model.Title_ar = dr["Title_ar"].ToString();
model.Description_tr = dr["Description_tr"].ToString();
model.Description_en = dr["Description_en"].ToString();
model.Description_de = dr["Description_de"].ToString();
model.Description_fr = dr["Description_fr"].ToString();
model.Description_ru = dr["Description_ru"].ToString();
model.Description_ar = dr["Description_ar"].ToString();
model.PostImage = dr["PostImage"].ToString();
model.Travel = dr["Travel"].ToString();
model.Active = Convert.ToBoolean(dr["Active"]);
model.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
// model.OpUserID = Convert.ToInt64(dr["OpUserID"]);
list.Add(model);
}
}
return list;
}
public void LoadData()
{
int mid = Request.QueryString["mid"].ToInt();
int cid = Request.QueryString["cid"].ToInt();
int PhuKien = 9;
DBEntities db = new DBEntities();
var query = from c in db.ProductCategories
from p in c.Products
where p.Status == true
orderby p.ProductID descending
select new
{
p.ProductID,
p.Title,
p.Avatar,
p.Price,
c.ProductCategoryID,
c.ProductMainCategoryID,
};
// nếu có dk Mid thì load theo danh mục maincategory
if (mid > 0)
{
query = query.Where(x => x.ProductMainCategoryID == mid);
}
else if (cid > 0)
{
query = query.Where(x => x.ProductCategoryID == cid);
}
else if (PhuKien > 0)
{
query = query.Where(x => x.ProductCategoryID == PhuKien);
}
else
{
Response.Redirect("/Default.aspx");
}
// nếu có dk cid thì load theo danh mục category
//Đổ vào Repeater
int pageSize = 12; //10 là số phần tử trên mỗi trang
int maxPage = 5; //5 là số trang tối đã sẽ hiển thị, còn lại là ...
int page = Request.QueryString["page"].ToInt(); // Trang hiện tại
if (page <= 0)
{
page = 1;
}
int totalItems = query.Count();
// .: Lưu ý sửa lại link cho đúng với trang và điều kiện thực tế của mỗi trang :. \\
string url = "~/ProductList.aspx?mid={0}&cid={1}&phukien={2}&page={3}".StringFormat(mid, cid, PhuKien, "{0}");
ucPagging.TotalItems = totalItems;
ucPagging.CurrentPage = page;
ucPagging.PageSize = pageSize;
ucPagging.MaxPage = maxPage;
ucPagging.URL = url;
ucPagging.DataBind();
Repeater_Main.DataSource = query.Pagging(page, pageSize).ToList();
Repeater_Main.DataBind();
}
public List<BizTbl_UserOperationExt> GetOperationType()
{
DBEntities entity = new DBEntities();
DataTable dt = new DataTable();
var Culture = new SqlParameter("@CultureCode", CultureCode);
dt.Columns.Add("ID");
dt.Columns.Add("Name");
List<BizTbl_UserOperationExt> ListOfModel = new List<BizTbl_UserOperationExt>();
var result = entity.Database.SqlQuery<GetOperationType_Result>("B_Ex_GetOperationType_TB_TypeOperation_SP @CultureCode", Culture).ToList();
foreach (GetOperationType_Result Val in result)
{
dt.Rows.Add(Val.ID, Val.Name);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
BizTbl_UserOperationExt HitObj = new BizTbl_UserOperationExt();
HitObj.ID = Convert.ToInt32(dr["ID"]);
HitObj.Name = dr["Name"].ToString();
ListOfModel.Add(HitObj);
}
}
return ListOfModel;
}
public PageController()
{
db = new DBEntities();
}
public int Update(string CurrentPassword,Controller Ctrl)
{
//string Encryptedoperations = Encrypt(CurrentPassword);
string Encryptedoperations = (new BizCrypto.AES128()).Encrypt(CurrentPassword);
DBEntities obj = new DBEntities();
var OpUserIDParameter = new SqlParameter("@OpUserID", Convert.ToInt64(Ctrl.Session["UserID"]));
var PasswordParameter = new SqlParameter("@Password", Encryptedoperations);
int i = obj.Database.ExecuteSqlCommand("B_Ex_UpdatePassword_BizTbl_User_SP @OpUserID,@Password", OpUserIDParameter, PasswordParameter);
return i;
}
public JsonResult Edit(EditViewModel model)
{
List <ErrorMsg> ErrorMsgs = new List <ErrorMsg>();
//新增
if (String.IsNullOrEmpty(model.SID))
{
model.SID = SystemIdHelper.getNewSId();
PRODUCT product = new PRODUCT()
{
SID = model.SID,
CDT = DateTime.Now,
MDT = DateTime.Now,
CSID = SystemIdHelper.getEmptySId(),
MSID = SystemIdHelper.getEmptySId(),
ENABLED = model.ENABLED,
NAME = model.NAME,
CAT_SID = model.CAT_SID,
CONTENT = Encoder.HtmlEncode(model.CONTENT),
DESC = model.DESC,
IMG_SRC = model.IMG_SRC,
PRICE = model.PRICE,
};
if (ErrorMsgs.Count > 0)
{
return(Json(new { Success = false, ErrorMsgs }));
}
using (DBEntities db = new DBEntities())
{
try
{
db.PRODUCTs.Add(product);
db.SaveChanges();
}
catch (Exception ex)
{
ErrorMsgs.Add(new ErrorMsg()
{
ErrorID = "Utility", ErrorText = ex.Message
});
return(Json(new { Success = false, ErrorMsgs }));
}
}
}
//修改
else
{
//查詢既有資料
using (DBEntities db = new DBEntities())
{
var oldInfo = db.PRODUCTs.AsNoTracking().Where(x => x.SID == model.SID).Single();
PRODUCT newInfo = new PRODUCT()
{
SID = model.SID,
CDT = oldInfo.CDT,
MDT = DateTime.Now,
CSID = oldInfo.CSID,
MSID = SystemIdHelper.getEmptySId(),
ENABLED = model.ENABLED,
NAME = model.NAME,
CAT_SID = model.CAT_SID,
CONTENT = Encoder.HtmlEncode(model.CONTENT),
DESC = model.DESC,
IMG_SRC = model.IMG_SRC,
PRICE = model.PRICE,
};
if (ErrorMsgs.Count > 0)
{
return(Json(new { Success = false, ErrorMsgs }));
}
db.Entry(newInfo).State = EntityState.Modified;
db.SaveChanges();
}
}
return(Json(new { Success = true }));
}
protected void LinkButton_Save_Click(object sender, EventArgs e)
{
//lấy id đang chọn
int id = DropDownList_Main.SelectedValue.ToInt();
DBEntities db = new DBEntities();
//nếu có id, thì kiểm tra tồn tại rồi UPDATE
if (id > 0)
{
var item = db.ProductMainCategories.Where(x => x.ProductMainCategoryID == id).FirstOrDefault();
if (item == null)
{
ucMessage.ShowError("loại tin tức này không tồn tại.");
return;
}
string title = input_Title.Value.Trim();
//tiêu đề không rỗng
if (title == string.Empty)
{
ucMessage.ShowError("vui lòng nhập tiêu đề");
input_Title.Focus();
return;
}
//kiểm tra hợp lệ:tiêu đề không trùng
var validateItem = db.ProductMainCategories.Where(x => x.Title == title && x.ProductMainCategoryID != id).FirstOrDefault();
if (validateItem != null)
{
ucMessage.ShowError("Vui lòng nhập tiêu đề không trùng với tiêu đề đã có");
input_Title.Focus();
return;
}
//nhập các thông tin mới
item.Position = input_Position.Value.ToInt();
item.Code = input_Code.Value.Trim();
item.Title = input_Title.Value.Trim();
item.Description = textarea_Description.Value.Trim();
//upload hình ảnh
//kiêm tra có file được chọn thì mới upload
if (FileUpload_Avatar.HasFile)
{
//kiểm tra cái file có cái đuôi hợp lệ: .jpg.png.gif.jpeg
string validFile = ".jpg.png.gif.jpeg";
string filename = FileUpload_Avatar.FileName;
string extension = Path.GetExtension(filename).ToLower();
if (!validFile.Contains(extension))
{
ucMessage.ShowError("vui lòng chọn ảnh có đuôi: .jpg.png.gif.jpeg");
return;
}
//chọn thư mục lưu trữ
string folderUrl = "/Images/ProductMainCategory/";
//tạo tên file ngẫu nhiên để lưu trữ
string randomName = Guid.NewGuid().ToString();
//tạo url lưu trữ = folder + tên ngẫu nhiên + đuôi upload
string saveUrl = folderUrl + randomName + extension;
//upload vào saveUrl
FileUpload_Avatar.SaveAs(Server.MapPath(saveUrl));
//cập nhập vào item của db
item.Avatar = saveUrl;
item.Thumb = saveUrl;
}
item.Status = radio_Active.Checked ? true : false;
item.CreateBy = SessionUility.AdminUsername;
//lưu db
db.SaveChanges();
LoadData();
ClearFrom();
ucMessage.ShowSuccess("Đã lưu dữ liệu.");
}
//Ngược lại.thì INSERT
else
{
ProductMainCategory item = new ProductMainCategory();
string title = input_Title.Value.Trim();
//tiêu đề không rỗng
if (title == string.Empty)
{
ucMessage.ShowError("vui lòng nhập tiêu đề");
input_Title.Focus();
return;
}
//kiểm tra hợp lệ:tiêu đề không trùng
var validateItem = db.ProductMainCategories.Where(x => x.Title == title).FirstOrDefault();
if (validateItem != null)
{
ucMessage.ShowError("Vui lòng nhập tiêu đề không trùng với tiêu đề đã có");
input_Title.Focus();
return;
}
//id ko trùng
//nhập thông tin
item.Code = input_Code.Value.Trim();
item.Position = input_Position.Value.ToInt();
item.Title = input_Title.Value.Trim();
item.Description = textarea_Description.Value.Trim();
if (FileUpload_Avatar.HasFile)
{
//kiểm tra cái file có cái đuôi hợp lệ: .jpg.png.gif.jpeg
string validFile = ".jpg.png.gif.jpeg";
string filename = FileUpload_Avatar.FileName;
string extension = Path.GetExtension(filename).ToLower();
if (!validFile.Contains(extension))
{
ucMessage.ShowError("vui lòng chọn ảnh có đuôi: .jpg.png.gif.jpeg");
return;
}
//chọn thư mục lưu trữ
string folderUrl = "/Images/ProductMainCategory/";
//tạo tên file ngẫu nhiên để lưu trữ
string randomName = Guid.NewGuid().ToString();
//tạo url lưu trữ = folder + tên ngẫu nhiên + đuôi upload
string saveUrl = folderUrl + randomName + extension;
//upload vào saveUrl
FileUpload_Avatar.SaveAs(Server.MapPath(saveUrl));
//cập nhập vào item của db
item.Avatar = saveUrl;
item.Thumb = saveUrl;
}
item.Status = radio_Active.Checked ? true : false;
item.CreateBy = SessionUility.AdminUsername;
//lưu db
db.ProductMainCategories.Add(item);
db.SaveChanges();
//load lại dữ liệu
LoadData();
// xóa form
ClearFrom();
//thông báo
ucMessage.ShowSuccess("Đã lưu dữ liệu");
}
}
//----------------------------------------------------------------- add data candidate ------------------------------------------
public static List <object> AddData(CandidateDTO DataNewCandidate, HttpPostedFileBase Pict, HttpPostedFileBase Cv)
{
using (DBEntities db = new DBEntities())
{
//generate id candidate
string Candidate_ID = "CA" + DateTime.Now.ToString("fffff");
//process file pict candidate
string pict_name = "-";
if (Pict != null)
{
string pict_ext = Pict.FileName.Split('.')[1];
pict_name = "Pict_" + Candidate_ID + "." + pict_ext;
string path_pict = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Pict/"), pict_name);
Pict.SaveAs(path_pict);
}
//process file Cv
string Cv_name = "-";
if (Cv != null)
{
string Cv_ext = Cv.FileName.Split('.')[1];
Cv_name = "Cv_" + Candidate_ID + "." + Cv_ext;
string path_cv = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Data/DataCandidate/Cv/"), Cv_name);
Cv.SaveAs(path_cv);
}
//process to convert datetime
var birth_date = Convert.ToDateTime(DataNewCandidate.CANDIDATE_BIRTH_DATE);
var edu_start_date = Convert.ToDateTime(DataNewCandidate.EDUCATON_START_DATE);
var edu_end_date = Convert.ToDateTime(DataNewCandidate.EDUCATON_END_DATE);
//process insert data
db.TB_CANDIDATE.Add(new TB_CANDIDATE
{
CANDIDATE_ID = Candidate_ID,
CANDIDATE_NAME = DataNewCandidate.CANDIDATE_NAME,
CANDIDATE_AGE = DataNewCandidate.CANDIDATE_AGE,
CANDIDATE_BIRTH_DATE = birth_date,
CANDIDATE_PLACE_BIRTH = DataNewCandidate.CANDIDATE_PLACE_BIRTH,
MARITAL_STATUS_ID = DataNewCandidate.MARITAL_STATUS_ID,
GENDER_ID = DataNewCandidate.GENDER_ID,
RELIGION_ID = DataNewCandidate.RELIGION_ID,
CANDIDATE_ETNIC = DataNewCandidate.CANDIDATE_ETNIC,
CANDIDATE_HOMENUMBER = DataNewCandidate.CANDIDATE_HOMENUMBER,
CANDIDATE_PHONENUMBER = DataNewCandidate.CANDIDATE_PHONENUMBER,
CANDIDATE_EMAIL = DataNewCandidate.CANDIDATE_EMAIL,
CANDIDATE_CITY = DataNewCandidate.CANDIDATE_CITY,
CANDIDATE_PROVINCE = DataNewCandidate.CANDIDATE_PROVINCE,
CANDIDATE_CURRENT_ADDRESS = DataNewCandidate.CANDIDATE_CURRENT_ADDRESS,
CANDIDATE_KTP_NUMBER = DataNewCandidate.CANDIDATE_KTP_NUMBER,
CANDDIATE_NPWP_NUMBER = DataNewCandidate.CANDDIATE_NPWP_NUMBER,
CANDIDATE_CV = Cv_name,
CANDIDATE_PHOTO = pict_name,
CANDIDATE_LAST_EDUCATON = DataNewCandidate.CANDIDATE_LAST_EDUCATON,
CANDIDATE_GPA = DataNewCandidate.CANDIDATE_GPA,
CANDIDATE_MAJOR = DataNewCandidate.CANDIDATE_MAJOR,
CANDIDATE_DEGREE = DataNewCandidate.CANDIDATE_DEGREE,
CANDIDATE_STATE_ID = 1,
SOURCE = DataNewCandidate.SOURCE,
SOURCING_DATE = DateTime.Now,
ZIP_CODE = DataNewCandidate.ZIP_CODE,
PARENT_ADDRESS = DataNewCandidate.PARENT_ADDRESS,
RESIDENT_CARD_NUMBER = DataNewCandidate.RESIDENT_CARD_NUMBER,
TELEPHONE_NUMBER = DataNewCandidate.TELEPHONE_NUMBER,
AVAILABLE_JOIN = DataNewCandidate.AVAILABLE_JOIN,
RECOMENDATION = DataNewCandidate.RECOMENDATION,
EXPECTED_SALARY = DataNewCandidate.EXPECTED_sALARY,
NOTES = DataNewCandidate.NOTES,
POSITION = DataNewCandidate.POSITION,
EDUCATION_START_DATE = edu_start_date,
EDUCATION_END_DATE = edu_end_date,
CANDIDATE_INTERVIEW_DATE = DataNewCandidate.CANDIDATE_INTERVIEW_DATE
});
int res = 0;
if (db.SaveChanges() > 0)
{
//insert skill
if (DataNewCandidate.CANDIDATE_SKILL != null)
{
foreach (string skill in DataNewCandidate.CANDIDATE_SKILL)
{
db.TB_CANDIDATE_SKILL.Add(new TB_CANDIDATE_SKILL
{
CANDIDATE_ID = db.TB_CANDIDATE.FirstOrDefault(c => c.CANDIDATE_ID == Candidate_ID).ID,
SKILL = skill
});
db.SaveChanges();
}
}
//insert selection history
UserDTO UserLogin = (UserDTO)HttpContext.Current.Session["UserLogin"];
Manage_CandidateSelectionHistoryDTO.AddData(new CandidateSelectionHistoryDTO
{
CANDIDATE_ID = db.TB_CANDIDATE.FirstOrDefault(ca => ca.CANDIDATE_ID == Candidate_ID).ID,
PIC_ID = UserLogin.USER_ID,
CANDIDATE_APPLIED_POSITION = DataNewCandidate.POSITION,
CANDIDATE_SUITABLE_POSITION = "-",
CANDIDATE_SOURCE = DataNewCandidate.SOURCE,
CANDIDATE_EXPECTED_SALARY = DataNewCandidate.EXPECTED_sALARY,
CANDIDATE_STATE = 1,
NOTES = DataNewCandidate.NOTES
});
db.SaveChanges();
res = 1;
}
return(new List <object>()
{
{ res }, { Candidate_ID }
});
}
}
protected void LinkButton_Save_Click(object sender, EventArgs e)
{
// LẤY ID Đang chọn
int id = DropDownList_Main.SelectedValue.ToInt();
DBEntities db = new DBEntities();
//Nếu ID có thì update
if (id > 0)
{
var item = db.PictureMainCategories
.Where(x => x.PictureMainCategoryID == id).FirstOrDefault();
if (item == null)
{
ucMessage.ShowError("Dữ Liệu Này Không Tồn Tại.");
return;
}
//kiểm tra có nhập dữ liệu vào ô chưa
if (input_Title.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Tiêu Đề");
return;
}
if (input_Position.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Vị Trí");
return;
}
if (textarea_Decription.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Mô Tả");
return;
}
// kiểm tra hợp lệ : tiêu đề không trùng
string title = input_Title.Value.Trim();
var valideItem = db.PictureMainCategories
.Where(x => x.Title == title && x.PictureMainCategoryID != id)
.FirstOrDefault();
if (valideItem != null)
{
ucMessage.ShowError("Vùi Lòng Nhập Tiêu Đề Không Trùng");
input_Title.Focus();
return;
}
// nhập các thông tin mới
item.Position = input_Position.Value.ToInt();
item.Code = input_Code.Value.Trim();
item.Title = input_Title.Value.Trim();
item.Description = textarea_Decription.Value.Trim();
//upload hình ảnh
//// kiểm tra có file dc chọn thì mới upload
if (FileUpload_Avatar.HasFile)
{
//// kiểm tra file có đuôi hợp lệ .jpg.png.gif.jpeg
string filename = FileUpload_Avatar.FileName;
string extension = Path.GetExtension(filename).ToLower();
string validFile = ".jpg.png.gif.jpeg";
if (!validFile.Contains(extension))
{
ucMessage.ShowError("Vui Lòng chọn ảnh có đuôi: .jpg.png.gif.jpeg");
return;
}
//chọn thư mục lưu trữ
string folder = "/FileUpload/image/PictureMainCategory/";
//tạo tên file ngẫu nhiên để lưu trữ
string radomName = Guid.NewGuid().ToString();
// tạo url lưu trữ = folder + tên ngẫu nhiên + đuôi upload
string saveUrl = folder + radomName + extension;
//upload vào saveUrl
FileUpload_Avatar.SaveAs(Server.MapPath(saveUrl));// server.MapPath là hàm chuyển về dg dẫn nội bộ server
//update vào item của db
item.Avatar = saveUrl;
item.Thumb = saveUrl;
}
item.Status = radio_Active.Checked ? true : false;
item.CreateBy = SessionUtility.AdminUsername;
//lưu db
db.SaveChanges();
LoadData();
// thông báo
ucMessage.ShowSuccess("Đã Update Dữ Liệu.");
}
//ngược lại thì insert
else
{
PictureMainCategory item = new PictureMainCategory();
// kiểm tra hợp lệ : tiêu đề không trùng
string title = input_Title.Value.Trim();
var valideItem = db.PictureMainCategories.Where(x => x.Title == title).FirstOrDefault();
if (valideItem != null)
{
ucMessage.ShowError("Vùi Lòng Nhập Tiêu Đề Không Trùng");
input_Title.Focus();
return;
}
//kiểm tra nhập dữ liệu vào ô chưa và kiểm tra tiêu đề k rỗng
if (input_Title.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Tiêu Đề");
return;
}
if (input_Position.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Vị trí");
return;
}
if (textarea_Decription.Value.Trim().IsNullOrEmpty())
{
ucMessage.ShowError("Mời Nhập Mô tả");
return;
}
// nhập các thông tin mới
item.Code = input_Code.Value.Trim();
item.Position = input_Position.Value.ToInt();
item.Title = input_Title.Value.Trim();
item.Description = textarea_Decription.Value.Trim();
//upload hình ảnh
//// kiểm tra có file dc chọn thì mới upload
if (FileUpload_Avatar.HasFile)
{
//// kiểm tra file có đuôi hợp lệ .jpg.png.gif.jpeg
string filename = FileUpload_Avatar.FileName;
string extension = Path.GetExtension(filename).ToLower();
string validFile = ".jpg.png.gif.jpeg";
if (!validFile.Contains(extension))
{
ucMessage.ShowError("Vùi Lòng chọn ảnh có đuôi: .jpg.png.gif.jpeg");
return;
}
//chọn thư mục lưu trữ
string folder = "/FileUpload/image/PictureMainCategory/";
//tạo tên file ngẫu nhiên để lưu trữ
string radomName = Guid.NewGuid().ToString();
// tạo url lưu trữ = folder + tên ngẫu nhiên + đuôi upload
string saveUrl = folder + radomName + extension;
//upload vào saveUrl
FileUpload_Avatar.SaveAs(Server.MapPath(saveUrl));// server.MapPath là hàm chuyển về dg dẫn nội server
//update vào item của db
item.Avatar = saveUrl;
item.Thumb = saveUrl;
}
else
{
item.Avatar = "/Admin/images/no_image.png";
item.Thumb = "/Admin/images/no_image.png";
}
item.Status = radio_Active.Checked ? true : false;
item.CreateBy = SessionUtility.AdminUsername;
//add item
db.PictureMainCategories.Add(item);
//lưu db
db.SaveChanges();
LoadData();
ClearFrom();
// thông báo
ucMessage.ShowSuccess("Đã Lưu Dữ Liệu");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int ID = Request.QueryString["ID"].ToInt();
if (ID != 0)
{
DBEntities db = new DBEntities();
var query = (from d in db.Menus
where d.MenuID == ID
select d).First();
query.Name = inputTitle.Value.Trim();
if (inputTitle.Value.Trim() == String.Empty)
{
inputTitle.Focus();
message.InnerHtml = "Nhập tên menu!";
message.Attributes["class"] = "text-center text-info col-12 m-2 bg-warning";
moreInfo.Visible = false;
return;
}
if (checkboxShow.Checked)
{
query.Show = true;
}
else
{
query.Show = false;
}
try
{
db.SaveChanges();
message.InnerHtml = "Lưu thay đổi thành công!";
message.Attributes["class"] = "text-center text-info col-12 m-2 bg-warning";
moreInfo.Visible = false;
LoadData();
}
catch (Exception)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Có lỗi')", true);
return;
}
}
else
{
bool show = false;
if (checkboxShow.Checked)
{
show = true;
}
if (inputTitle.Value.Trim() == String.Empty)
{
inputTitle.Focus();
message.InnerHtml = "Nhập tên menu!";
message.Attributes["class"] = "text-center text-info col-12 m-2 bg-warning";
moreInfo.Visible = false;
return;
}
using (var context = new DBEntities())
{
var std = new Menu()
{
Name = inputTitle.Value.Trim(),
NameLink = "",
Show = show,
Positon = 99,
NguoiDungID = Session["ID"].ToInt()
};
context.Menus.Add(std);
try
{
context.SaveChanges();
message.InnerHtml = "Thêm Mới thành công!";
message.Attributes["class"] = "text-center text-info col-12 m-2 bg-sucess";
moreInfo.Visible = false;
LoadData();
}
catch (Exception)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Có lỗi')", true);
return;
}
}
}
}
private void UpdateArray(DBEntities context, SecurityRoleModel model, SecurityRole target)
{
model.Groups = model.Groups ?? new List<Guid>();
foreach (SecurityGroup item in target.SecurityGroup.ToList())
{
if (!model.Groups.Contains(item.Id))
target.SecurityGroup.Remove(item);
}
foreach (SecurityGroup item in context.SecurityGroup.Where(
s => model.Groups.Contains(s.Id)).ToList())
{
if (!target.SecurityGroup.Any(any => item.Id == any.Id))
target.SecurityGroup.Add(item);
}
}
public ActionResult Edit(int id)
{
DBEntities e = COREobject.i.Context;
return(View("~/Views/Athena/Form.cshtml", e.Graph.Single(g => g.Id == id)));
}
/// <summary>
/// 获取医生状态配置
/// </summary>
/// <param name="room"></param>
/// <returns></returns>
public List <ResponseConversationRoomDocConfDTO> GetDoctorConfigs(string DoctorID, DBEntities db = null)
{
#region 获取医生配置
var CacheKey = new StringCacheKey(StringCacheKeyType.Doctor_Configs, DoctorID);
var doctorConfigs = CacheKey.FromCache <List <ResponseConversationRoomDocConfDTO> >();
if (doctorConfigs == null)
{
bool dbPrivateFlag = false;
if (db == null)
{
db = CreateDb();
dbPrivateFlag = true;
}
doctorConfigs = db.DoctorConfigs.Where(x => !x.IsDeleted && x.DoctorID == DoctorID).Select(x => new ResponseConversationRoomDocConfDTO
{
DoctorID = DoctorID,
ConfigType = x.ConfigType,
ConfigContent = x.ConfigContent
}).ToList();
if (dbPrivateFlag)
{
db.Dispose();
}
if (doctorConfigs != null)
{
doctorConfigs.ToCache(CacheKey);
}
}
return(doctorConfigs);
#endregion
}
public VendedorController()
{
db = new DBEntities();
val = new validacion();
}
/// <summary>
/// 获取最后的日志
/// </summary>
/// <param name="ConversationRoomID"></param>
/// <param name="OperatorType"></param>
/// <param name="db"></param>
/// <returns></returns>
public ResponseConversationRoomLogDTO GetChannelLastLog(string ConversationRoomID, string OperatorType, DBEntities db = null)
{
bool dbPrivateFlag = false;
if (db == null)
{
db = CreateDb();
dbPrivateFlag = true;
}
var log = db.ConversationRoomLogs.Where(a => a.ConversationRoomID == ConversationRoomID && a.OperatorType == OperatorType).OrderByDescending(a => a.OperationTime).FirstOrDefault();
if (dbPrivateFlag)
{
db.Dispose();
}
return(log.Map <ConversationRoomLog, ResponseConversationRoomLogDTO>());
}
private void btnAceptar_Click(object sender, RoutedEventArgs e)
{
using (DBEntities db = new DBEntities())
{
if (txt_apellidopaterno.Text.Equals("") || txt_apellidomaterno.Text.Equals("") || txt_name.Text.Equals("") ||
txt_curp.Text.Equals("") || txt_rfc.Text.Equals("") || combo_genero.SelectedItem == null ||
combo_pais.SelectedItem == null || combo_estado.SelectedItem == null || combo_ciudad.SelectedItem == null || cbEstadoCivil.SelectedItem == null)
{
MessageBox.Show(Settings.Default.MensajeCamposVacios);
}
else
{
Cliente existe = db.Clientes.Where(b => b.rfc == txt_rfc.Text).FirstOrDefault();
if (existe != null)
{
MessageBox.Show(Settings.Default.MensajeYaExiste);
txt_rfc.Text = "";
}
else
{
Cliente nuevo = new Cliente();
nuevo.rfc = txt_rfc.Text;
nuevo.nombre = txt_name.Text;
nuevo.apellidoPaterno = txt_apellidopaterno.Text;
nuevo.apellidoMaterno = txt_apellidomaterno.Text;
foreach (Pai pais in Paises)
{
if (pais.pais.Equals(combo_pais.SelectedItem))
{
//nuevo.Pai = pais;
nuevo.idPais = pais.idPais;
}
}
foreach (Estado estado in Estados)
{
if (estado.estado1.Equals(combo_estado.SelectedItem))
{
//nuevo.Estado = estado;
nuevo.idEstado = estado.idEstado;
}
}
foreach (Ciudad ciudad in Ciudades)
{
if (ciudad.ciudad1.Equals(combo_ciudad.SelectedItem))
{
//nuevo.Ciudad = ciudad;
nuevo.idCiudad = ciudad.idCiudad;
}
}
nuevo.curp = txt_curp.Text;
nuevo.fechaNacimiento = date_nacimiento.SelectedDate.Value;
nuevo.genero = combo_genero.Text;
nuevo.estadoCivil = cbEstadoCivil.Text;
nuevo.estatus = "activo";
db.Clientes.Add(nuevo);
db.SaveChanges();
MessageBox.Show(Settings.Default.MensajeExito);
;
RegistrarCliente registrarDomicilio = new RegistrarCliente(nuevo);
registrarDomicilio.WindowStartupLocation = WindowStartupLocation.CenterScreen;
this.Hide();
registrarDomicilio.ShowDialog();
closeWindow();
}
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, IConfiguration configuration, DBEntities dBEntities)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMvc();
// Check if Starup is invoked by entityFramework and if so we can't continue because of infinite loop in Observer
StackTrace stackTrace = new StackTrace();
List <string> efMethods = new List <string>()
{
"RemoveMigration", "AddMigration", "UpdateDatabase"
};
if (stackTrace.GetFrames().Any(f => efMethods.Contains(f.GetMethod().Name)))
{
return;
}
RabbitMessenger.Setup(configuration, env);
Observer.Setup(configuration);
}
public UserRepositoryImpl(DBEntities db) : base(db)
{
}
public ProductoController()
{
db = new DBEntities();
val = new validacion();
}
public int Register(string fullName, string email, string username, string password)
{
//Kiểm tra Email
DBEntities db = new DBEntities();
if (db.Users.FirstOrDefault(x => x.Email == email) != null)
{
return(1);
}
if (db.Users.FirstOrDefault(x => x.UserID == username) != null)
{
return(2);
}
//Tạo thành viên mới
User item = new User();
item.Email = email;
item.FullName = fullName;
string passwordEncript = "tamgiacvuong";
item.Password = password.SHA256Hash(passwordEncript);
item.UserID = username;
item.StatusJob = false;
item.CreateTime = DateTime.Now;
item.Status = false;
//Gửi mail thông báo và yêu cầu kích hoạt
MailUtility mail = new MailUtility();
mail.Host = "smtp.gmail.com";
mail.Port = 587;
mail.EnableSSL = true;
mail.IsBodyHtml = true;
mail.From = "*****@*****.**";
mail.Password = "******";
mail.To = email;
mail.Subject = "Kích hoạt tài khoản";
string template = Server.MapPath("~/MailTemplate/active.html");
mail.Body = FileUtility.ReadFile(template);
string domain = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority);
string emailEncript = string.Empty;
emailEncript = email.AES256Encrypt(passwordEncript);
string url = "{0}/Active.aspx?id={1}".StringFormat(domain, emailEncript);
mail.Body = mail.Body.Replace("~name~", username);
mail.Body = mail.Body.Replace("~url~", url);
Exception error = null;
mail.SendMail(ref error);
if (error != null)
{
return(3);
}
//Lưu vào DB
db.Users.Add(item);
db.SaveChanges();
return(4);
}
public string UpdateEmail(string ID, string Template, string MailFrom, string MailTo, string ResentCount, string SendingDate, string Subject, string Content, string MailCC, string SentStatus, string Record, Controller ctrl)
{
string status ="Success";
using (DBEntities DE = new DBEntities())
{
long Id = Convert.ToInt64(ID);
var MailTable = DE.BizTbl_MailQueue.Where(x => x.ID == Id).FirstOrDefault();
MailTable.MailTemplateID = Convert.ToInt32(Template);
MailTable.MailFrom = MailFrom;
MailTable.MailTo = MailTo;
MailTable.MailCC = MailCC;
MailTable.Subject = Subject;
MailTable.Body = Content;
MailTable.IsSent = Convert.ToBoolean(SentStatus);
if (ResentCount == "")
{
MailTable.ResentCount = 0;
}
else
{
MailTable.ResentCount = Convert.ToInt32(ResentCount);
}
MailTable.SendingDateTime = DateTime.Now;
if (Record == "")
{
MailTable.RecordID = null;
}
else
{
MailTable.RecordID = Convert.ToInt64(Record);
}
DE.SaveChanges();
}
return status;
}
public int UpdateFirmOperations(string UserCode, string Firm, string Country, string Region, string Address, string Phone, string Fax, string Postcode,
string Email, string TaxOffice, string TaxID, string ExecutiveTitle, string ExecutiveName, string ExecutiveSurname, string ExecutivePosition, string ExecutivePhone, string ExecutiveEmail,
string Active, string Status, string IPAddress)
{
DBEntities UpdateUserOperationsobj = new DBEntities();
var UserCodeParameter = new SqlParameter("@UserCode", UserCode);
var FirmParameter = new SqlParameter("@Firm", Firm);
var CountryParameter = new SqlParameter("@Country", Country);
var RegionParameter = new SqlParameter("@Region", Convert.ToInt64(Region));
var AddressParameter = new SqlParameter("@Address", Address);
var PhoneParameter = new SqlParameter("@Phone", Phone);
var FaxParameter = new SqlParameter("@Fax", Fax);
var PostcodeParameter = new SqlParameter("@Postcode", Postcode);
var EmailParameter = new SqlParameter("@Email", Email);
var TaxOfficeParameter = new SqlParameter("@TaxOffice", TaxOffice);
var TaxIDParameter = new SqlParameter("@TaxID", TaxID);
var ExecutiveTitleParameter = new SqlParameter("@ExecutiveTitle", ExecutiveTitle);
var ExecutiveNameParameter = new SqlParameter("@ExecutiveName", ExecutiveName);
var ExecutiveSurnameParameter = new SqlParameter("@ExecutiveSurname", ExecutiveSurname);
var ExecutivePositionParameter = new SqlParameter("@ExecutivePosition", ExecutivePosition);
var ExecutivePhoneParameter = new SqlParameter("@ExecutivePhone", ExecutivePhone);
var ExecutiveEmailParameter = new SqlParameter("@ExecutiveEmail", ExecutiveEmail);
var ActiveParameter = new SqlParameter("@Active", Convert.ToBoolean(Active));
var StatusParameter = new SqlParameter("@Status", Convert.ToInt32(Status));
var IPAddressParameter = new SqlParameter("@IPAddress", IPAddress);
int i = UpdateUserOperationsobj.Database.ExecuteSqlCommand("B_UpdateFirmOperations_TB_Firm_SP @UserCode,@Firm,@Country,@Region,@Address,@Phone,@Fax,@Postcode,@Email,@TaxOffice,@TaxID,@ExecutiveTitle,@ExecutiveName,@ExecutiveSurname,@ExecutivePosition,@ExecutivePhone,@ExecutiveEmail,@Active,@Status,@IPAddress",
UserCodeParameter, FirmParameter, CountryParameter, RegionParameter, AddressParameter, PhoneParameter, FaxParameter, PostcodeParameter, EmailParameter,
TaxOfficeParameter, TaxIDParameter, ExecutiveTitleParameter, ExecutiveNameParameter, ExecutiveSurnameParameter, ExecutivePositionParameter,
ExecutivePhoneParameter, ExecutiveEmailParameter, ActiveParameter,StatusParameter,IPAddressParameter);
return i;
}
public bool Delete(CountryExt model, ref string Msg, Controller ctrl)
{
bool status = true;
using (DBEntities DE = new DBEntities())
{
var MessageTable = DE.TB_Country.Where(x => x.ID == model.ID).FirstOrDefault();
DE.TB_Country.Remove(MessageTable);
DE.SaveChanges();
}
return status;
}
private void Validate(DBEntities context, MetaFormModel model)
{
//string res = MetaFormValidator.CheckTableName(context, model.Id, model.TableName);
//if (res.Length > 0)
// ModelState.AddModelError("TableName", res);
}
public bool Create(CountryExt model, ref string Msg, Controller ctrl)
{
bool status = true;
DBEntities insertentity = new DBEntities();
TB_Country MsgObj = new TB_Country();
MsgObj.CurrencyID = model.CurrencyID;
MsgObj.Name_en = model.Name;
MsgObj.Code = model.Code;
MsgObj.CultureCode = model.CultureCode;
MsgObj.VAT = Convert.ToInt32(model.VAT);
MsgObj.HasCityTax = model.CityTax;
MsgObj.HitCount = model.HitCount;
MsgObj.Sort = model.Sort;
MsgObj.Active = model.Active;
MsgObj.TempCode = Convert.ToInt32(model.TemparoryCode);
MsgObj.OpDateTime= DateTime.Now;
MsgObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
insertentity.TB_Country.Add(MsgObj);
insertentity.SaveChanges();
int id = MsgObj.ID;
return status;
}
public int SaveHotelRoom(string HotelRoomID, int HotelID, string RoomType, string RoomCount, string RoomSize, string RoomMaxPeopleCount, string RoomMaxChildrenCount, string BabyCotCount, string ExtraBedCount,
string SmokingStatus, string ViewType, string Culture, string Description, Controller ctrl)
{
DBEntities insertentity = new DBEntities();
TB_HotelRoom hotelRoom = new TB_HotelRoom();
string culturecode = "";
if (HotelRoomID != string.Empty)
{
int HotelRoomIdValue = Convert.ToInt32(HotelRoomID);
hotelRoom = db.TB_HotelRoom.Where(x => x.ID == HotelRoomIdValue).FirstOrDefault();
// hotelRoom = db.TB_HotelRoom.Where(x => x.ID == Convert.ToInt32(HotelRoomID)).FirstOrDefault();
// hotelRoom = (from room in DataContext.TB_HotelRoomswhere room.ID == HotelRoomID).Single;
}
hotelRoom.HotelID = Convert.ToInt32(HotelID);
hotelRoom.RoomTypeID = Convert.ToInt32(RoomType);
hotelRoom.RoomCount = Convert.ToInt32(RoomCount);
hotelRoom.RoomSize = Convert.ToInt32(RoomSize);
hotelRoom.MaxPeopleCount = Convert.ToInt16(RoomMaxPeopleCount);
hotelRoom.MaxChildrenCount = Convert.ToInt16(RoomMaxChildrenCount);
hotelRoom.BabyCotCount = Convert.ToInt16(CheckEmptyStringDBParameter(BabyCotCount, true));
hotelRoom.ExtraBedCount = Convert.ToInt16(CheckEmptyStringDBParameter(ExtraBedCount, true));
hotelRoom.ViewTypeID = (Nullable<int>)CheckEmptyStringDBParameter(ViewType, true);
hotelRoom.SmokingTypeID = (Nullable<int>)CheckEmptyStringDBParameter(SmokingStatus, true);
if (Description != string.Empty)
{
if(Culture == "1")
{
culturecode ="en";
}
else if (Culture == "3")
{
culturecode = "de";
}
else if (Culture == "4")
{
culturecode = "fr";
}
else if (Culture == "10")
{
culturecode = "ar";
}
else if (Culture == "6")
{
culturecode = "ru";
}
else if (Culture == "8")
{
culturecode = "tr";
}
SetColumn(hotelRoom, "Description_" + culturecode, Description);
}
hotelRoom.Active = true;
hotelRoom.OpDateTime = DateTime.Now;
hotelRoom.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]);
if (HotelRoomID == string.Empty)
{
hotelRoom.CreateDateTime = DateTime.Now;
hotelRoom.CreateUserID = Convert.ToInt64(ctrl.Session["UserID"]);
db.TB_HotelRoom.Add(hotelRoom);
// db.SaveChanges();
// DataContext.TB_HotelRooms.InsertOnSubmit(hotelRoom);
}
db.SaveChanges();
// DataContext.SubmitChanges();
return hotelRoom.ID;
}
public bool Update(EmailExt model, ref string Msg, Controller ctrl)
{
bool status = true;
using (DBEntities DE = new DBEntities())
{
var MailTable = DE.BizTbl_MailQueue.Where(x => x.ID == model.ID).FirstOrDefault();
MailTable.MailTemplateID = model.MailTemplateID;
MailTable.MailFrom = model.MailFrom;
MailTable.MailTo = model.MailTo;
MailTable.MailCC = model.MailCC;
MailTable.MailCC = model.MailCC;
MailTable.Subject = model.Subject;
MailTable.Body = model.Content;
MailTable.IsSent = Convert.ToBoolean(model.SentStatus);
MailTable.ResentCount = model.ResentCount;
MailTable.SendingDateTime = DateTime.Now;
MailTable.RecordID = Convert.ToInt64(model.Record);
DE.SaveChanges();
}
return status;
}
public static Materia Get(int?id)
{
DBEntities db = new DBEntities();
return(db.Materia.Find(id));
}
public int DeleteEMail(int ID)
{
int status = 1;
using (DBEntities DE = new DBEntities())
{
var MessageTable = DE.BizTbl_MailQueue.Where(x => x.ID == ID).FirstOrDefault();
DE.BizTbl_MailQueue.Remove(MessageTable);
DE.SaveChanges();
}
return status;
}
public static List <Materia> List()
{
DBEntities db = new DBEntities();
return(db.Materia.ToList());
}
public int SysConfiguration(string Secret, string CreditCard, string NotificationCulture, Controller ctrl,int id)
{
DBEntities obj = new DBEntities();
var SecretParameter = new SqlParameter("@Secret", Secret);
var CreditCardParameter = new SqlParameter("@CreditCard", CreditCard);
var NotificationCultureParameter = new SqlParameter("@NotificationCulture", NotificationCulture);
var OpUserIDParameter = new SqlParameter("@OpUserID", Convert.ToInt64(ctrl.Session["UserID"]));
var HotelIDParameter = new SqlParameter("@ID", id);
int i = obj.Database.ExecuteSqlCommand("B_Ex_UpdateSystemConfig_TB_Hotel_SP @Secret,@CreditCard,@NotificationCulture,@OpUserID,@ID", SecretParameter, CreditCardParameter, NotificationCultureParameter, OpUserIDParameter, HotelIDParameter);
return i;
}
public List <DataUser> GetUser(int page, int pageSize, TypeSearchModel modelSearch)
{
int skip = (page - 1) * pageSize;
int take = pageSize;
DBEntities db = new DBEntities();
var data = db.Users
.OrderBy(x => x.Position)
.Select(x => new DataUser
{
Avatar = x.Avatar != null ? x.Avatar : string.Empty,
FullName = x.FullName != null ? x.FullName : string.Empty,
UserID = x.UserID != null ? x.UserID : string.Empty,
NameSchool = x.NameSchool != null ? x.NameSchool : string.Empty,
JobStatus = x.StatusJob == null ? false : x.StatusJob.Value,
CreateTime = x.CreateTime.Value,
Tag = x.TagSkill != null ? x.TagSkill : string.Empty,
IDCompany = x.CompanyID == null ? 0 : x.CompanyID.Value,
TitleCompany = x.Company.Title != null ? x.Company.Title : string.Empty,
GraduationYear = x.GraduationYear == null ? 0: x.GraduationYear.Value,
Skill = string.Empty,
FlagPage = false
});
string keySearch = modelSearch.KeySearch.ToSafetyString();
if (modelSearch.Type == "muti")
{
foreach (var item in modelSearch.KeySearch.SplitToTextValueArray(";", ":", StringSplitOptions.RemoveEmptyEntries))
{
if (item.Text == "sk")
{
data = data.Where(x => x.Tag != null && x.Tag.Contains(item.Value));
}
if (item.Text == "sc")
{
data = data.Where(x => x.NameSchool.Contains(item.Value));
}
}
}
if (modelSearch.Type == "sk")
{
data = data.Where(x => x.Tag != null && x.Tag.Contains(keySearch));
}
if (modelSearch.Type == "sc")
{
data = data.Where(x => x.NameSchool.Contains(keySearch));
}
if (modelSearch.Type == "cp")
{
int idCompany = keySearch.ToInt();
data = data.Where(x => x.IDCompany == idCompany);
}
if (modelSearch.Type == "job")
{
if (modelSearch.KeySearch == "1")
{
data = data.Where(x => x.JobStatus == true);
}
if (modelSearch.KeySearch == "2")
{
data = data.Where(x => x.JobStatus == false);
}
}
if (modelSearch.Type == "keyname")
{
data = data.Where(x => x.FullName.Contains(modelSearch.KeySearch));
}
List <DataUser> listUser = new List <DataUser>();
int coutData = data.Count();
int demFist = 0;
foreach (var item in data)
{
demFist++;
item.Skill = MyUtility.LoadSkill(item.UserID);
if (demFist == coutData)
{
item.FlagPage = true;
}
listUser.Add(item);
}
return(listUser.Skip(skip).Take(take).ToList());
}
private void ValidateGroup(DBEntities context, SecurityPermissionGroupModel model)
{
//string res = SecurityPermissionGroupValidator.CheckTableName(context, model.Id, model.TableName);
//if (res.Length > 0)
// ModelState.AddModelError("TableName", res);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Lấy mã đơn hàng
int orderID = Request.QueryString["order_code"].ToInt();
//Lấy hình thức thanh toán
int paymentMethod = Request.QueryString["payment_type"].ToInt();
//Cho tình trạng thanh toán mặc định là chưa trả tiền
bool isCheckoutOK = false;
//Nếu khách chọn trả tiền tại nhà
if (paymentMethod == 0)
{
ucMessage.ShowSuccess("Xin chúc mừng, đơn hàng của bạn đã được lập. Bạn có thể thanh toán sau khi nhận được hàng tại nhà. <a href='OrderDetail.aspx'>xem Đơn Hàng Tại Đây</a> Hoặc Quý Khách Hãy Vào Email Của Mình Để Kiểm Tra");
DBEntities db = new DBEntities();
var order = db.Orders.Where(o => o.OrderID == orderID).FirstOrDefault();
//Gửi một email xác nhận đơn hàng đã thanh toán cho khách
string fullname = order.FullName;
string ID = order.Code + order.OrderID;
string date = order.CreateTime.ToString();
int payment = order.PaymentMethod.ToInt();
int phone = order.Mobi.ToInt();
int phone2 = order.Mobi2.ToInt();
string address = order.Address;
string email = order.Email;
//gửi email
MailUtility emailItem = new MailUtility();
emailItem.From = "*****@*****.**";
emailItem.Password = "******";
emailItem.To = "*****@*****.**";
emailItem.Subject = "Thư liên hệ ngày: "
+ DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
emailItem.Port = 587;
emailItem.Host = "smtp.gmail.com";
emailItem.EnableSSL = true;
emailItem.IsBodyHtml = true;
string emailBody = string.Empty;
emailBody += "Chủ Đề: Xác Nhận Đặt Hàng " + "<br>";
emailBody += "Kính chào quý khách: " + fullname + "<br>";
emailBody += "VườnSenĐáBD vừa nhận được <p>đơn hàng: </p>" + ID + "của quý khách đặt hàng vào ngày: " + date;
emailBody += "Nội dung:Chúng Tôi Gửi Đến quý khánh lá thư này nhầm xác nhận việc đặt hàng của quý khách " + "<br>";
if (payment == 0)
{
emailBody += "Hình Thức Thanh Toán Là: Thanh Toán Qua Ngân Lượng " + "<br>";
}
else
{
emailBody += "Hình Thức Thanh Toán Là: Thanh Toán Tại Nhà " + "<br>";
}
emailBody += "SĐT 1: " + phone + "<br>";
emailBody += "SĐT 2: " + phone2 + "<br>";
emailBody += "Địa Chỉ Giao Hàng: " + address + "<br>";
emailBody += "Vào lúc: "
+ DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
emailItem.Body = emailBody;
try
{
emailItem.SendMail();
}
catch (Exception ex)
{
ucMessage.ShowError("Không gửi được email, hãy thử lại sau");
return;
}
SessionUtility.Cart.CartItems.Clear();
}
else //Thanh toán trực tuyến tại ngân lượng
{
isCheckoutOK = ValidateCheckout();
}
//Cập nhật lại tình trạng thanh toán của đơn hàng
if (isCheckoutOK) //Nếu thanh toán Online thành công
{
//Vào DB, tìm đơn hàng theo mã đơn hàng trả về
DBEntities db = new DBEntities();
var order = db.Orders.Where(q => q.OrderID == orderID).FirstOrDefault();
//Nếu có đơn hàng và đơn hàng chưa cập nhật trạng thái trả tiền,
// Thì cập nhật
if (order != null && order.ChargeStatus != true)
{
order.ChargeStatus = true;
db.SaveChanges();
SessionUtility.Cart.CartItems.Clear();
}
//Gửi một email xác nhận đơn hàng đã thanh toán cho khách
string fullname = order.FullName;
string ID = order.Code + order.OrderID;
string date = order.CreateTime.ToString();
int payment = order.PaymentMethod.ToInt();
int phone = order.Mobi.ToInt();
int phone2 = order.Mobi2.ToInt();
string address = order.Address;
string email = order.Email;
//gửi email
MailUtility emailItem = new MailUtility();
emailItem.From = "*****@*****.**";
emailItem.Password = "******";
emailItem.To = "*****@*****.**";
emailItem.Subject = "Thư liên hệ ngày: "
+ DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
emailItem.Port = 587;
emailItem.Host = "smtp.gmail.com";
emailItem.EnableSSL = true;
emailItem.IsBodyHtml = true;
string emailBody = string.Empty;
emailBody += "Chủ Đề: Xác Nhận Đặt Hàng " + "<br>";
emailBody += "Kính chào quý khách: " + fullname + "<br>";
emailBody += "VườnSenĐáBD vừa nhận được <p>đơn hàng: </p>" + ID + "của quý khách đặt hàng vào ngày: " + date;
emailBody += "Nội dung:Chúng Tôi Gửi Đến quý khánh lá thư này nhầm xác nhận việc đặt hàng của quý khách " + "<br>";
if (payment == 0)
{
emailBody += "Hình Thức Thanh Toán Là: Thanh Toán Qua Ngân Lượng " + "<br>";
}
else
{
emailBody += "Hình Thức Thanh Toán Là: Thanh Toán Tại Nhà " + "<br>";
}
emailBody += "SĐT 1: " + phone + "<br>";
emailBody += "SĐT 2: " + phone2 + "<br>";
emailBody += "Địa Chỉ Giao Hàng: " + address + "<br>";
emailBody += "Vào lúc: "
+ DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
emailItem.Body = emailBody;
try
{
emailItem.SendMail();
}
catch (Exception ex)
{
ucMessage.ShowError("Không gửi được email, hãy thử lại sau");
return;
}
return;
}
}
}
private void Validate(DBEntities context, MetaFormBlockModel model)
{
}
private void Validate(DBEntities context, FormBlockTemplateModel model)
{
//string res = MetaFormBlockTemplateValidator.CheckTableName(context, model.Id, model.TableName);
//if (res.Length > 0)
// ModelState.AddModelError("TableName", res);
}
