public static int Update(Register register)
{
using (var connect = new inventorymanagementEntities())
{
Register target = connect.Registers
.Where(x => x.ID == register.ID)
.SingleOrDefault();
if (target != null)
{
target.Name = register.Name;
target.UnSignedName = UnSign.convert(register.Name);
target.Phone = register.Phone;
target.ProvinceID = register.ProvinceID;
target.Note = register.Note;
target.ProductCategory = register.ProductCategory;
target.Status = register.Status;
target.UserID = register.UserID;
target.CreatedDate = register.CreatedDate;
target.ModifiedDate = DateTime.Now;
target.Referer = register.Referer;
connect.SaveChanges();
}
}
return(register.ID);
}
public static int Insert(Register register)
{
using (var connect = new inventorymanagementEntities())
{
Regex digitsOnly = new Regex(@"[^\d]");
string numberphone = digitsOnly.Replace(register.Phone, "");
Register newRegister = new Register();
newRegister.ID = GetIDNew();
newRegister.Name = register.Name;
newRegister.UnSignedName = UnSign.convert(register.Name);
newRegister.Phone = numberphone;
newRegister.Address = register.Address;
newRegister.ProvinceID = register.ProvinceID;
newRegister.Note = register.Note;
newRegister.ProductCategory = register.ProductCategory;
newRegister.Status = register.Status;
newRegister.UserID = register.UserID;
newRegister.CreatedDate = DateTime.Now;
newRegister.Referer = register.Referer;
connect.Registers.Add(newRegister);
connect.SaveChanges();
return(newRegister.ID);
}
}
public static List <tbl_TransportCompany> Filter(string TextSearch)
{
using (var con = new inventorymanagementEntities())
{
if (!String.IsNullOrEmpty(TextSearch))
{
var unsignTextSearch = UnSign.convert(TextSearch);
var tran = con.tbl_TransportCompany
.Where(x => x.SubID == 0)
.OrderBy(x => x.CompanyName)
.ToList();
var tranSub = con.tbl_TransportCompany
.Where(x => x.SubID != 0)
.OrderBy(x => x.CompanyName)
.ToList();
var data = tran
.GroupJoin(
tranSub,
t => t.ID,
tb => tb.ID,
(t, tb) => new { t, tb }
)
.SelectMany(
x => x.tb.DefaultIfEmpty(),
(parent, child) => new {
transfor = parent.t,
CompanyName = parent.t.CompanyName,
CompanyAddress = parent.t.CompanyAddress,
CompanyPhone = parent.t.CompanyPhone,
ShipTo = child != null? child.ShipTo : String.Empty
}
)
.Where(x =>
UnSign.convert(x.CompanyName).Contains(unsignTextSearch) ||
UnSign.convert(x.CompanyAddress).Contains(unsignTextSearch) ||
UnSign.convert(x.ShipTo).Contains(unsignTextSearch) ||
x.CompanyPhone == unsignTextSearch
)
.Select(x => x.transfor)
.OrderBy(x => x.CompanyName)
.ToList();
return(data);
}
else
{
return(con.tbl_TransportCompany
.Where(x => x.SubID == 0)
.OrderBy(x => x.CompanyName)
.ToList());
}
}
}
public static string Insert(string CustomerName, string CustomerPhone, string CustomerAddress, string CustomerEmail, int CustomerLevelID, int Status,
DateTime CreatedDate, string CreatedBy, bool IsHidden, string Zalo, string Facebook, string Note, string Nick, string Avatar = "", int ShippingType = 0, int PaymentType = 0, int TransportCompanyID = 0, int TransportCompanySubID = 0, string CustomerPhone2 = "", int ProvinceID = 0, int DistrictID = 0, int WardID = 0)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Customer ui = new tbl_Customer();
ui.CustomerName = CustomerName;
ui.UnSignedName = UnSign.convert(CustomerName);
ui.CustomerPhone = CustomerPhone;
ui.CustomerAddress = CustomerAddress;
ui.CustomerEmail = CustomerEmail;
ui.CustomerLevelID = CustomerLevelID;
ui.Status = Status;
ui.CreatedDate = CreatedDate;
ui.CreatedBy = CreatedBy;
ui.IsHidden = IsHidden;
ui.Zalo = Zalo;
ui.Facebook = Facebook;
ui.Note = Note;
ui.Nick = Nick;
ui.UnSignedNick = UnSign.convert(Nick);
ui.Avatar = Avatar;
ui.ShippingType = ShippingType;
ui.PaymentType = PaymentType;
ui.TransportCompanyID = TransportCompanyID;
ui.TransportCompanySubID = TransportCompanySubID;
ui.CustomerPhone2 = CustomerPhone2;
ui.ProvinceID = ProvinceID;
ui.DistrictId = DistrictID;
ui.WardId = WardID;
try
{
dbe.tbl_Customer.Add(ui);
dbe.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
int kq = ui.ID;
return(kq.ToString());
}
}
public static string Update(int ID, string CustomerName, string CustomerPhone, string CustomerAddress, string CustomerEmail, int CustomerLevelID, int Status,
string CreatedBy, DateTime ModifiedDate, string ModifiedBy, bool IsHidden, string Zalo, string Facebook, string Note, string Nick, string Avatar, int ShippingType, int PaymentType, int TransportCompanyID, int TransportCompanySubID, string CustomerPhone2, int ProvinceID, int DistrictID, int WardID)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Customer ui = dbe.tbl_Customer.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.CustomerName = CustomerName;
ui.UnSignedName = UnSign.convert(CustomerName);
ui.CustomerPhone = CustomerPhone;
ui.CustomerAddress = CustomerAddress;
ui.CustomerEmail = CustomerEmail;
ui.CustomerLevelID = CustomerLevelID;
ui.Status = Status;
ui.CreatedBy = CreatedBy;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
ui.IsHidden = IsHidden;
ui.Zalo = Zalo;
ui.Facebook = Facebook;
ui.Note = Note;
ui.Nick = Nick;
ui.UnSignedNick = UnSign.convert(Nick);
ui.Avatar = Avatar;
ui.ShippingType = ShippingType;
ui.PaymentType = PaymentType;
ui.TransportCompanyID = TransportCompanyID;
ui.TransportCompanySubID = TransportCompanySubID;
ui.CustomerPhone2 = CustomerPhone2;
ui.ProvinceID = ProvinceID;
ui.DistrictId = DistrictID;
ui.WardId = WardID;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
private void button7_Click(object sender, EventArgs e)
{
S s = new S();
XmlData xd = new XmlData();
//s.nonstr = "1133";
s.c = "33";
s.d = "44";
s.z = 3;
//s.o = new O();
//s.o.e = "";
//s.o.f = "ff";
s.nonstr = "33";
s.ArrayOfTaa = new List<Taa>();
Taa taa = new Taa();
taa.f = "ff";
taa.e = "ee";
s.ArrayOfTaa.Add(taa);
s.Taa = taa;
s.list = new List<string>();
s.ints = new int[1];
s.ints[0] = 2;
s.strs = new string[2];
//F f = new F();
//f.s = new S();
//string str = UnToGen.getFields(typeof(S));
//string s1 = UnEncSign.splitJoint(s, null, false)+"&key=123";
string s2 = new UnSign("123").sign(s);
//string str = UnEncSign.sign(s,"123", UnEncSignEnu.MD5);
//s.nonstr = "333";
//bool isSign = UnEncSign.validSign(s.ArrayOfTaa, "123", UnEncSignEnu.MD5, str);
// SortedDictionary<string, string> sort = UnToGen.getSignSortedDictionary<S>(s);
//List<string> list = UnToGen.getSqlFields<S>();
//Console.WriteLine(list.Count);
//string str = UnEncSign.sign(s, null, "123", UnEncSignEnu.MD5);
//bool b = UnEncSign.validSign(s, null, "123", UnEncSignEnu.MD5, str);
//SortedDictionary<string, object> dic = UnToGen.tToSDic(s, null);
Console.WriteLine(s2);
}
