public bool InsertCompany(emCompany model)
{
#region set default
model.RowFlag = 2;
model.RowVersion = 1;
model.CreatedBy = "sa";
model.ModifiedBy = "sa";
model.ModifiedDate = DateTimeNow;
model.CreatedDate = DateTimeNow;
#endregion
qDB.emCompanies.InsertOnSubmit(model);
qDB.SubmitChanges();
IsResult = true;
return(IsResult);
}
public bool UserRegister(Ouikum.Common.Register model)
{
EncryptManager encrypt = new EncryptManager();
emMember member = new emMember();
emMemberWeb memberWeb = new emMemberWeb();
//emMemberActivate memberActivate = new emMemberActivate();
emCompany company = new emCompany();
emCompanyProfile compProfile = new emCompanyProfile();
Ouikum.Common.emCompanyService svCompany = new Ouikum.Common.emCompanyService(qDB);
#region Set ค่า เข้า Member
if (model.MemberID > 0)
{
member.emMemberID = (int)model.MemberID;
}
member.UserName = model.UserName.Trim();
member.Password = encrypt.EncryptData(model.Password);
member.DisplayName = model.DisplayName.Trim();
member.AddrLine1 = model.AddrLine1;
member.Email = model.Emails.Trim();
member.FirstName = model.FirstName_register.Trim();
member.LastName = model.LastName.Trim();
member.CountryID = model.CountryID;
member.ProvinceID = model.ProvinceID;
member.DistrictID = model.DistrictID;
member.MemberType = model.MemberType;
member.Phone = model.Phone;
member.PostalCode = model.PostalCode;
member.Mobile = model.Mobile;
member.Fax = model.Fax;
member.IsShow = true;
member.RegisDate = DateTimeNow;
member.FacebookID = model.FacebookID;
#endregion
#region Set ค่า เข้า memberWeb
if (model.WebID > 0)
{
memberWeb.WebID = model.WebID;
}
else
{
memberWeb.WebID = 1;
}
#endregion
#region Set ค่า เข้า company
company.CompName = model.CompName.Trim();
company.DisplayName = model.DisplayName.Trim();
company.CompEmail = model.Emails.Trim();
company.BizTypeID = Convert.ToInt32(model.BizTypeID);
company.CompAddrLine1 = model.AddrLine1;
company.CompCountryID = model.CountryID;
company.CompProvinceID = model.ProvinceID;
company.CompDistrictID = model.DistrictID;
company.CompPostalCode = model.PostalCode;
company.CompPhone = model.Phone;
company.CompMobile = model.Mobile;
company.CompFax = model.Fax;
company.IsShow = true;
if (model.BizTypeID == 13 && !string.IsNullOrEmpty(model.BizTypeOther))
{
company.BizTypeOther = model.BizTypeOther;
}
#endregion
#region Set ค่า เข้า companyProfile
compProfile.CompName = model.CompName.Trim();
compProfile.AddrLine1 = model.AddrLine1;
compProfile.CountryID = model.CountryID;
compProfile.ProvinceID = model.ProvinceID;
compProfile.DistrictID = model.DistrictID;
compProfile.PostalCode = model.PostalCode;
compProfile.IsShow = true;
if (model.BizTypeID > 0)
{
compProfile.CompBizType = (byte)model.BizTypeID;
}
else
{
compProfile.CompBizType = 13;
}
if (model.BizTypeID == 13 && !string.IsNullOrEmpty(model.BizTypeOther))
{
compProfile.CompBizTypeOther = model.BizTypeOther.Trim();
}
#endregion
try
{
using (var trans = new TransactionScope())
{
InsertMember(member);
memberWeb.MemberID = member.MemberID;
InsertMemberWeb(memberWeb);
//memberActivate.MemberID = member.MemberID;
//InsertMemberActivate(memberActivate);
company.MemberID = member.MemberID;
svCompany.InsertCompany(company);
compProfile.CompID = company.CompID;
svCompany.InsertCompanyProfile(compProfile);
#region Set ID ที่ได้ เข้า Register Model กลับไป
model.MemberID = member.MemberID;
model.emCompID = company.CompID;
model.emCompProfileID = compProfile.CompProfileID;
#endregion
trans.Complete();
IsResult = true;
}
if (!IsResult)
{
DeleteMember(member.MemberID);
DeleteMemberWeb(member.MemberID);
DeleteMemberActivate(member.MemberID);
DeleteCompany(member.MemberID);
}
}
catch (Exception ex)
{
IsResult = false;
}
return(IsResult);
}
public bool UpdateCompany(emCompany model)
{
return(IsResult);
}
public ActionResult editcompany(
int compid,
string image,
string name,
string nameeng,
string tel,
string mobile,
string fax,
string email,
string website,
string address,
int province,
int district
)
{
var svCompany = new CompanyService();
var svMember = new CompanyService();
var b2bCompany = new b2bCompany();
var emCompanies = new emCompany();
string compimg;
string complogo;
var Company = svCompany.SelectData <b2bCompany>("*", " CompID = " + compid + "");
b2bCompany = Company.First();
#region set ค่า b2bCompany
compimg = b2bCompany.CompImgPath;
complogo = b2bCompany.LogoImgPath;
b2bCompany.LogoImgPath = image;
b2bCompany.CompName = name;
b2bCompany.CompNameEng = nameeng;
b2bCompany.CompAddrLine1 = address;
b2bCompany.CompDistrictID = district;
b2bCompany.CompProvinceID = province;
b2bCompany.CompPhone = tel;
b2bCompany.CompMobile = mobile;
b2bCompany.CompWebsiteUrl = website;
#endregion
#region Update b2bCompany
svCompany.SaveData <b2bCompany>(b2bCompany, "CompID");
#endregion
if (svCompany.IsResult)
{
emCompanies = svMember.SelectData <emCompany>("*", " CompID = " + b2bCompany.emCompID).First();
#region set ค่า emCompany
emCompanies.LogoImgPath = b2bCompany.LogoImgPath;
emCompanies.CompName = b2bCompany.CompName;
emCompanies.DisplayName = b2bCompany.DisplayName;
emCompanies.CompNameEng = b2bCompany.CompNameEng;
emCompanies.CompAddrLine1 = b2bCompany.CompAddrLine1;
emCompanies.CompDistrictID = b2bCompany.CompDistrictID;
emCompanies.CompProvinceID = b2bCompany.CompProvinceID;
emCompanies.CompPostalCode = b2bCompany.CompPostalCode;
emCompanies.CompPhone = b2bCompany.CompPhone;
emCompanies.CompMobile = b2bCompany.CompMobile;
emCompanies.CompFax = b2bCompany.CompFax;
emCompanies.BizTypeID = b2bCompany.BizTypeID;
emCompanies.BizTypeOther = b2bCompany.BizTypeOther;
emCompanies.CompWebsiteUrl = b2bCompany.CompWebsiteUrl;
emCompanies.RowVersion = b2bCompany.RowVersion;
#endregion
#region Update emCompany
svMember.SaveData <emCompany>(emCompanies, "CompID");
#endregion
if (svCompany.IsResult && svMember.IsResult)
{
#region SaveLogo
if (image != "")
{
if (b2bCompany.LogoImgPath != complogo)
{
imgManager = new FileHelper();
//#region Delete Folder
//imgManager.DeleteFilesInDir("Companies/Logo/" + b2bCompany.CompID);
//#endregion
imgManager.DirPath = "Companies/Logo/" + b2bCompany.CompID;
imgManager.DirTempPath = "Temp/Companies/Logo/" + b2bCompany.CompID;
imgManager.ImageName = image;
//imgManager.ImageThumbName = "Thumb_" + form["LogoImgPath"];
imgManager.FullHeight = 150;
imgManager.FullWidth = 150;
//imgManager.ThumbHeight = 150;
//imgManager.ThumbWidth = 150;
imgManager.SaveImageFromTemp();
}
}
#endregion
}
}
return(Json(new { status = svCompany.IsResult }, JsonRequestBehavior.AllowGet));
}
