private bool ValidateBuylead(b2bBuylead model)
{
//Example
if (model.BuyleadName == null)
{
IsResult = false;
}
else if (model.BuyleadNameEng == null)
{
IsResult = false;
}
return(IsResult);
}
public bool InsertBuylead(b2bBuylead Buylead, int CompID)
{
// bom ยังไม่ได้ทดสอบ method ครับ
using (var trans = new TransactionScope())
{
qDB.b2bBuyleads.InsertOnSubmit(Buylead);
qDB.SubmitChanges();
trans.Complete();
IsResult = true;
}
return(IsResult);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBuylead(b2bBuylead model)
{
var data = qDB.b2bBuyleads.Single(q => q.BuyleadID == model.BuyleadID);
#region Set Model
// set ค่า model BuyleadInfo
data.BuyleadName = model.BuyleadName;
data.BuyleadCode = model.BuyleadCode;
data.BuyleadType = model.BuyleadType;
data.BuyleadExpDate = model.BuyleadExpDate;
data.BuyleadKeyword = model.BuyleadKeyword;
data.BuyleadDetail = model.BuyleadDetail;
data.Qty = model.Qty;
data.QtyUnit = model.QtyUnit;
data.CateLV1 = model.CateLV1;
data.CateLV2 = model.CateLV2;
data.CateLV3 = model.CateLV3;
data.BuyleadIMGPath = model.BuyleadIMGPath;
//set ค่า Model Contact Info
data.BuyleadCompanyName = model.BuyleadCompanyName;
data.BuyleadContactPerson = model.BuyleadContactPerson;
data.BuyleadContactPosition = model.BuyleadContactPosition;
data.BuyleadTel = model.BuyleadTel;
data.BuyleadEmail = model.BuyleadEmail;
data.BuyleadMobilePhone = model.BuyleadMobilePhone;
data.BuyleadFax = model.BuyleadFax;
data.BuyleadAddressLine1 = model.BuyleadAddressLine1;
data.DistrictID = model.DistrictID;
data.ProvinceID = model.ProvinceID;
data.BuyleadPostelCode = model.BuyleadPostelCode;
// default
data.RowVersion++;
data.ModifiedBy = model.ModifiedBy;
data.ModifiedDate = DateTimeNow;
data.RowFlag = model.RowFlag;
#endregion
#region Save
using (var trans = new TransactionScope())
{
qDB.SubmitChanges();// บันทึกค่า Buylead
trans.Complete();
IsResult = true;
}
#endregion
return(IsResult);
}
public bool SaveBuylead(b2bBuylead model)
{
IsResult = true;
if (!ValidateBuylead(model))
{
return(IsResult);
}
using (var trans = new TransactionScope())
{
try
{
if (model.BuyleadID > 0)
{
qDB.b2bBuyleads.Context.Refresh(RefreshMode.KeepCurrentValues, model);
qDB.b2bBuyleads.InsertOnSubmit(model);// ทำการ save
qDB.SubmitChanges();
}
else
{
qDB.b2bBuyleads.InsertOnSubmit(model);
qDB.SubmitChanges();
}
trans.Complete();
}
catch (Exception ex)
{
IsResult = false;
MsgError.Add(ex);
}
}
return(IsResult);
}
public ActionResult AddBuylead(FormCollection form, List <string> BuyleadImgPath, List <string> BuyLeadImgOldfile)
{
var svBuylead = new BuyleadService();
b2bBuylead model = new b2bBuylead();
try
{
#region Set Buylead Model
var date = form["BuyleadExpire"];
model.BuyleadName = form["BuyleadName"];
model.BuyleadCode = form["BuyleadCode"];
model.BuyleadType = DataManager.ConvertToInteger(form["BuyleadType"]);
//model.BuyleadExpDate = DateTime.Parse(form["BuyleadExpire"]);
var d = form["BuyleadExpire"];
DateTime t = DataManager.ConvertToDateTime(d);
model.BuyleadExpDate = t;
model.BuyleadKeyword = form["BuyleadKeyword"];
if (form["BuyleadDetail"] != "")
{
model.BuyleadDetail = form["BuyleadDetail"];
}
model.Qty = DataManager.ConvertToDecimal(form["Qty"]);
model.QtyUnit = form["QtyUnit"];
if (BuyleadImgPath != null)
{
model.BuyleadIMGPath = BuyleadImgPath[0];
}
model.CompID = LogonCompID;
model.CateLV1 = Convert.ToInt32(form["Catecode"].Substring(9, 4));
model.CateLV2 = Convert.ToInt32(form["Catecode"].Substring(14, 4));
model.CateLV3 = Convert.ToInt32(form["CateLV3"]);
model.IsShow = true;
model.IsJunk = false;
#region Check ว่าเป็น OutSource Add หรือ User Add
model.RowFlag = (LogonServiceType >= 9) ? (short)2 : (short)6;
#endregion
if (LogonServiceType >= 9)
{
model.CompCode = LogonCompCode;
}
#region Company Information
model.BuyleadCompanyName = form["CompName"];
model.BuyleadContactPerson = form["ContactName"];
model.BuyleadContactPosition = form["Position"];
model.BuyleadTel = form["Phone"];
model.BuyleadEmail = form["Email"];
if (form["Mobile"] != "")
{
model.BuyleadMobilePhone = form["Mobile"];
}
if (form["Fax"] != "")
{
model.BuyleadFax = form["Fax"];
}
if (form["Address"] != "")
{
model.BuyleadAddressLine1 = form["Address"];
}
model.DistrictID = Convert.ToInt32(form["District"]);
model.ProvinceID = Convert.ToInt32(form["Province"]);
if (form["Postal"] != "")
{
model.BuyleadPostelCode = form["Postal"];
}
#endregion
#endregion
model.ContactCount = 0;
model.ListNo = 0;
model.ViewCount = 0;
model.CreatedDate = DateTime.Now;
model.ModifiedDate = DateTime.Now;
model.CreatedBy = "sa";
model.ModifiedBy = "sa";
if (form["BuyleadID"] == null)
{
#region Insert Buylead And BuyleadImage
svBuylead.InsertBuylead(model, LogonCompID);
#endregion
}
else
{
#region Update Data
if (Convert.ToInt32(form["RowFlag"]) == 3)
{
model.RowFlag = 2;
}
model.BuyleadID = Convert.ToInt32(form["BuyleadID"]);
svBuylead.UpdateBuylead(model);
#endregion
}
var Floder = 0;
if (LogonCompID > 0)
{
Floder = LogonCompID;
}
else
{
Floder = 2;
}
#region Save Image Files
if (BuyleadImgPath != null)
{
imgManager = new FileHelper();
imgManager.DirPath = "Buylead/" + Floder + "/" + model.BuyleadID;
imgManager.DirTempPath = "Temp/Buylead/" + Floder;
SaveFileImage(
imgManager.DirTempPath,
imgManager.DirPath,
BuyleadImgPath, 150, 450);
if (BuyLeadImgOldfile != null && (BuyleadImgPath[0] != BuyLeadImgOldfile[0]))
{
DeleteFileImage(imgManager.DirPath, BuyLeadImgOldfile, BuyleadImgPath);
}
}
#endregion
}
catch (Exception ex)
{
CreateLogFiles(ex);
}
return(Json(new { IsResult = svBuylead.IsResult, MsgError = GenerateMsgError(svBuylead.MsgError), ID = model.BuyleadID }));
}
public bool SendEmailApproveBuylead(b2bBuylead model)
{
#region variable
bool IsSend = true;
var Detail = "";
var url = "";
var urlBuylead = "";
var mailTo = new List <string>();
var mailCC = new List <string>();
var svHotFeat = new HotFeaProductService();
var SQLSelect_Feat = "";
SQLSelect_Feat = " ProductID,ProductName,CompID,ProductImgPath,ProRowFlag,CompRowFlag,ProvinceName,Price,Ispromotion,PromotionPrice,HotPrice";
var HotProduct = svHotFeat.SelectHotProduct <view_HotFeaProduct>(SQLSelect_Feat, "Rowflag = 3 AND Status = 'H' AND ProductID > 0 AND ProRowFlag in(2,4) AND CompRowFlag in(2,4) AND ProductDelete = 0", "NEWID(),HotPrice DESC", 1, 4);
#endregion
#region Set Content & Value For Send Email
string urlb2bthai = res.Pageviews.UrlWeb;
url = urlb2bthai + "/MyB2B/buylead";
urlBuylead = urlb2bthai + "/Purchase/Search/Detail/" + model.BuyleadID + "?name=" + model.BuyleadName;
//test path logo
string b2bthai_url = res.Pageviews.UrlWeb;
string pathlogo = b2bthai_url + "/Content/Default/logo/Ouikum/img_Logo120x74.png";
Hashtable EmailDetail = new Hashtable();
EmailDetail["Name"] = model.BuyleadContactPerson;
EmailDetail["CompName"] = model.BuyleadCompanyName;
EmailDetail["BuyleadCode"] = model.BuyleadCode;
EmailDetail["BuyleadName"] = model.BuyleadName;
EmailDetail["Remark"] = model.Remark;
EmailDetail["pathLogo"] = pathlogo;
EmailDetail["url"] = url;
EmailDetail["urlBuylead"] = urlBuylead;
if (model.RowFlag == 4)
{
EmailDetail["Title"] = "แจ้งผลอนุมัติประกาศซื้อสินค้าของคุณ";
EmailDetail["Result"] = res.Admin.lblApprove;
}
else if (model.RowFlag == 3)
{
EmailDetail["Title"] = "แจ้งผลไม่อนุมัติประกาศซื้อสินค้าของคุณ";
EmailDetail["Result"] = res.Admin.lblReject;
}
ViewBag.Data = EmailDetail;
ViewBag.HotProduct = HotProduct;
string Subject = "แจ้งผลการตรวจสอบประกาศซื้อสินค้า B2BThai.com";
Detail = PartialViewToString("UC/Email/SendApproveBuylead");
var mailFrom = res.Config.EmailNoReply;
mailTo.Add(model.BuyleadEmail);
#endregion
IsSend = OnSendByAlertEmail(Subject, mailFrom, mailTo, mailCC, Detail);
return(IsSend);
}
