private void Button_Click_1(object sender, RoutedEventArgs e)
{
Class_Employee emp = new Class_Employee
{
EmpName = "aaa",
HireDate = DateTime.Now,
EmpImage = @"D:\WPFPractice2\WPFPractice2\WpfApp2\WpfApp_Class\PokemonGo\pic_001.png"
};
stackpanel1.DataContext = emp;
}
protected void Page_Load(object sender, EventArgs e)
{
//Response.Cache.SetExpires(DateTime.Now.AddSeconds(60));
//Response.Cache.SetCacheability(HttpCacheability.Public);
//Response.Cache.SetValidUntilExpires(false);
if (Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()] == null)
{
Response.Redirect("/adminwitcommerce/login-soft.aspx?returnUrl=" + Request.RawUrl);
}
else
{
Class_Employee emp = new Class_Employee();
dynamic employee = emp.Dynamic_GetData_By_Token(Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value.ToString());
string name = employee.GetType().GetProperty("Name").GetValue(employee, null);
lblEmployee.Text = name;
//MASUKIN ROLE KE HIDDEN ID
HiddenIDRole.Value = employee.GetType().GetProperty("IDRole").GetValue(employee, null).ToString();
}
}
private int ImportCombination(int idProduct, string referenceCode, decimal basePrice, decimal priceBeforeImpact, decimal impactPrice, decimal PriceAfterImpact, decimal price, decimal impactWeight, decimal weight, int Quantity, int idColor, int idSize)
{
try
{
DataClassesDataContext db = new DataClassesDataContext();
int firstQty = 0;
Class_Employee emp = new Class_Employee();
var employee = emp.GetData_By_Token(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value);
if (db.TBProduct_Combinations.Where(x => !x.Deflag && x.ReferenceCode == referenceCode).FirstOrDefault() != null)
{
TBProduct_Combination data = db.TBProduct_Combinations.Where(x => !x.Deflag && x.ReferenceCode == referenceCode).FirstOrDefault();
firstQty = data.Quantity;
data.Quantity = Quantity;
db.SubmitChanges();
return(data.IDProduct_Combination);
}
TBProduct_Combination _newData = new TBProduct_Combination();
TBValue color = db.TBValues.Where(x => !x.Deflag && x.IDValue == idColor).FirstOrDefault();
TBValue size = db.TBValues.Where(x => !x.Deflag && x.IDValue == idSize).FirstOrDefault();
_newData.IDProduct = idProduct;
_newData.ReferenceCode = referenceCode;
_newData.Name = color.TBAttribute.Name + " : " + color.Name + ", " + size.TBAttribute.Name + " : " + size.Name;
_newData.DateInsert = DateTime.Now;
_newData.DateLastUpdate = DateTime.Now;
_newData.BasePrice = basePrice;
_newData.PriceBeforeImpact = priceBeforeImpact;
_newData.PriceAfterImpact = PriceAfterImpact;
_newData.Price = price;
_newData.WeightBeforeImpact = weight;
_newData.Weight = weight;
_newData.Quantity = Quantity;
_newData.DateLastUpdate = DateTime.Now;
_newData.DateInsert = DateTime.Now;
db.TBProduct_Combinations.InsertOnSubmit(_newData);
db.SubmitChanges();
//INSERT DETAIL COMBINATAION COLOR
TBProduct_Combination_Detail _detail = new TBProduct_Combination_Detail();
_detail.IDProduct_Combination = _newData.IDProduct_Combination;
_detail.IDValue = color.IDValue;
_detail.NameAttribute = color.TBAttribute.Name;
_detail.NameValue = color.Name;
_detail.DateInsert = DateTime.Now;
db.TBProduct_Combination_Details.InsertOnSubmit(_detail);
//INSERT DETAIL COMBINATAION Size
TBProduct_Combination_Detail _detailSize = new TBProduct_Combination_Detail();
_detailSize.IDProduct_Combination = _newData.IDProduct_Combination;
_detailSize.IDValue = size.IDValue;
_detailSize.NameAttribute = size.TBAttribute.Name;
_detailSize.NameValue = size.Name;
_detailSize.DateInsert = DateTime.Now;
db.TBProduct_Combination_Details.InsertOnSubmit(_detailSize);
db.SubmitChanges();
//INSERT LOG
Class_Log_Stock log = new Class_Log_Stock();
log.Insert(employee.IDEmployee, _detail.TBProduct_Combination.IDProduct_Combination, _detail.TBProduct_Combination.Name, firstQty, Quantity, Quantity, "initial", "Import master product" + " by " + employee.Name + "( " + employee.Email + " )");
return(_newData.IDProduct_Combination);
}
catch (Exception)
{
return(0);
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (fuFile.HasFile)
{
lblSuccess.Text = "";
lblError.Text = "";
try
{
DataClassesDataContext db = new DataClassesDataContext();
Class_Employee emp = new Class_Employee();
var test = emp.DecryptToken(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value);
if (emp.DecryptToken(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value) != null && HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()] != null)
{
fuFile.SaveAs(Server.MapPath("~/assets/import/inventory/" + fuFile.FileName));
StreamReader sr = new StreamReader(Server.MapPath("~/assets/import/inventory/" + fuFile.FileName));
try
{
CsvReader csvread = new CsvReader(sr);
csvread.Configuration.Delimiter = ";";
csvread.Configuration.HasHeaderRecord = false;
char[] delimeter = { ',' };
List <CSV_Inventory> record = csvread.GetRecords <CSV_Inventory>().ToList();
int totalRead = 0;
int totalNotfound = 0;
int totalUpdate = 0;
foreach (var item in record)
{
totalRead++;
TBProduct_Combination data = db.TBProduct_Combinations.Where(x => !x.Deflag && x.TBProduct.ReferenceCode == item.ReferenceCodeProduct && x.ReferenceCode == item.ReferenceCodeCombination).FirstOrDefault();
var employee = emp.GetData_By_Token(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value);
if (data != null)
{
string jenis = "";
data.Quantity = item.Quantity;
if (data.Quantity > item.Quantity)
{
jenis = "decrease";
}
else
{
jenis = "increase";
}
db.SP_Update_Qty(item.ReferenceCodeCombination, item.Quantity);
totalUpdate++;
TBLog_Stock log = new TBLog_Stock();
log.Description = "import inventory";
log.IDEmployee = employee.IDEmployee;
log.IDProduct_Combination = data.IDProduct_Combination;
log.ProductName = data.TBProduct.Name;
log.UserName = employee.Name;
log.Type = jenis;
log.Quantity = item.Quantity;
log.InsertDate = DateTime.Now;
db.TBLog_Stocks.InsertOnSubmit(log);
db.SP_Insert_LogStock("import inventory", employee.IDEmployee, data.IDProduct_Combination, data.TBProduct.Name, employee.Name, jenis, item.Quantity, DateTime.Now);
}
else
{
totalNotfound++;
}
}
sr.Close();
lblSuccess.Text += totalRead + " row(s) read, " + totalUpdate + " row(s) updated, " + totalNotfound + " row(s) not found data";
alertError.Style.Add(HtmlTextWriterStyle.Display, "none");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "block");
}
catch (Exception ex)
{
sr.Close();
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
if (fuFile.HasFile)
{
lblSuccess.Text = "";
lblError.Text = "";
try
{
DataClassesDataContext db = new DataClassesDataContext();
Class_Employee emp = new Class_Employee();
//if (emp.DecryptToken(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value) == null || HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()] == null)
{
fuFile.SaveAs(Server.MapPath("~/assets/import/customer/" + fuFile.FileName));
StreamReader sr = new StreamReader(Server.MapPath("~/assets/import/customer/" + fuFile.FileName));
try
{
CsvReader csvread = new CsvReader(sr);
csvread.Configuration.Delimiter = ";";
csvread.Configuration.HasHeaderRecord = false;
char[] delimeter = { ',' };
List <CSV_Customer> record = csvread.GetRecords <CSV_Customer>().ToList();
int totalRead = 0;
int totalNotfound = 0;
int totalUpdate = 0;
List <TBCustomer> listCustomer = new List <TBCustomer>();
foreach (var item in record)
{
totalRead++;
TBCustomer cust = db.TBCustomers.Where(x => !x.Deflag && x.IDCustomer_Group == 1 && x.Email == item.Email).FirstOrDefault();
//var employee = emp.GetData_By_Token(HttpContext.Current.Request.Cookies[System.Configuration.ConfigurationManager.AppSettings["cookieAdmin"].ToString()].Value);
if (cust == null)
{
TBCustomer newCust = new TBCustomer();
newCust.FirstName = item.FirstName;
newCust.LastName = item.LastName;
newCust.Email = item.Email;
if (item.Gender == 2)
{
newCust.Gender = "P";
}
else
{
newCust.Gender = "L";
}
newCust.DateInsert = DateTime.ParseExact(item.CreateDate, "dd/MM/yyyy H:mm", System.Globalization.CultureInfo.InvariantCulture);
newCust.DateLastUpdate = DateTime.ParseExact(item.LastUpdateDate, "dd/MM/yyyy H:mm", System.Globalization.CultureInfo.InvariantCulture);
if (item.Birthday != null && item.Birthday != "NULL")
{
newCust.Birthday = DateTime.ParseExact(item.Birthday, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
}
newCust.IDCustomer_Group = 1;
newCust.Active = true;
newCust.Password = "";
//Class_Customer classCustomer = new Class_Customer();
//string text = item.Email + "-" + item.FirstName.Substring(0, 2);
//string pass = classCustomer.EncryptToken(item.Email, DateTime.Now.ToString("MMddHHmmss"));
//newCust.Password = pass;
listCustomer.Add(newCust);
db.SP_Insert_Customer(1, item.FirstName, item.LastName, newCust.Gender, item.Email, "", "", newCust.Birthday, true, newCust.DateInsert, newCust.DateLastUpdate);
}
else
{
totalNotfound++;
}
}
//db.TBCustomers.InsertAllOnSubmit(listCustomer);
//db.SubmitChanges();
foreach (var item in listCustomer)
{
Class_Customer classCustomer = new Class_Customer();
classCustomer.AJAX_Forget_Password(item.Email);
}
sr.Close();
lblSuccess.Text += totalRead + " row(s) read, " + totalUpdate + " row(s) updated, " + totalNotfound + " row(s) customer exists";
alertError.Style.Add(HtmlTextWriterStyle.Display, "none");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "block");
}
catch (Exception ex)
{
sr.Close();
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
alertError.Style.Add(HtmlTextWriterStyle.Display, "block");
alertSuccess.Style.Add(HtmlTextWriterStyle.Display, "none");
}
}
}
