public bool FindNewImages(Product product)
{
d = new DataClasses1DataContext();
bannedHosts = d.BannedImagesSites.Select(t => t.BannedHost).ToList();
bannedImages = d.BannedImages.Select(t => t.BannedImage1).ToList();
potentialImages.Clear();
var productName = product.ProductFullName;
foreach (var c in chars)
{
productName = productName.Replace(c, " ");
}
var searchURL = "http://ajax.googleapis.com/ajax/services/search/images?v=1.0&q=" + productName;
var findResult = PageEncoding.GetPage(searchURL, null, null, ip, port);
if (findResult == null || findResult.Contains("Bot or Human"))
{
return false;
}
// выбираем самую большую
GetImagesList(findResult);
foreach (var potentialImage in potentialImages.OrderByDescending(t => t.ContentLength).ToList())
{
var result = GetImage(potentialImage);
if (result)
{
//imageHost = potentialImage.ResponseUri.Host;
imageHost = potentialImage.ResponseUri.AbsoluteUri.Replace("www.", "");
return true;
}
}
return false;
}
public ActionResult Details(int id)
{
DataClasses1DataContext db = new DataClasses1DataContext();
OrderAndServies orderservies = new OrderAndServies();
List<ListServiesModif> listServies = new List<ListServiesModif>();
/*
List<list_add_services> servies = new List<list_add_services>();
//var order = db.Orders.Where(item => item.Id_order == id);
var order = db.ExecuteQuery<Order>(@"SELECT * FROM Orders WHERE Id_order = " + id + ";");
Order ddd = order.First();
*/
var ttt = db.ExecuteQuery<OrderModific>(@"SELECT [Orders].[Id_order], [Orders].[date], [Orders].[begin], [Orders].[end], [Client].[FIO] FROM [Orders], [Client] WHERE Orders.Id_order = '" + id + "' AND Orders.id_client = Client.Id_client;").ToList<OrderModific>().First();
//listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();
//listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100)) FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "'GROUP BY CAST([list_add_services].[Id_list_add_services] AS NVARCHAR(100)), CAST([list_add_services].[Id_order] AS NVARCHAR(100)), CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();
//listServies = db.ExecuteQuery<ListServiesModif>(@"SELECT [list_add_services].[Id_list_add_services], [list_add_services].[id_order], CAST([type_servies].[name] AS NVARCHAR(100)) AS 'name' FROM [list_add_services], [type_servies], [Orders] WHERE [list_add_services].[id_servies] = [type_servies].[Id_servies] AND [list_add_services].[id_order] = '" + id + "' GROUP BY [list_add_services].[Id_list_add_services], [list_add_services].[Id_order], CAST([type_servies].[name] AS NVARCHAR(100));").ToList<ListServiesModif>();
/*
orderservies.order = ttt;
orderservies.ListServirecs = listServies;
*/
return View(orderservies);
}
// Delete Bank <bank> from database
public static bool delete(Bank bank)
{
using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
{
var query = from a in database.Banks
where (a.BankID == bank.BankID)
select a;
// It seems to me that a single account renders the foreach unnecessary. However, I can't
// find another way to get the variable 'a' from 'query'.
foreach (var a in query)
{
database.Banks.DeleteOnSubmit(a);
try
{
database.SubmitChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
return false;
}
}
public static void AddCommoditypopularityByID(Guid id)
{
DataClasses1DataContext dd = new DataClasses1DataContext();
//在存储过程中加1了？？？
//dc.updatePopularityCommodity(id);
dd.updatePopularityCommodity(id);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if(!String.IsNullOrWhiteSpace(textBox1.Text) &&
!String.IsNullOrWhiteSpace(textBox2.Text) &&
!String.IsNullOrWhiteSpace(textBox3.Text))
{
DataClasses1DataContext doctorContext= new DataClasses1DataContext();
Doctor doctor = new Doctor();
doctor.doctorName = textBox1.Text;
doctor.doctorID = textBox2.Text;
doctor.gloveSize = Decimal.Parse(textBox3.Text);
doctorContext.Doctors.InsertOnSubmit(doctor);
doctorContext.SubmitChanges();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
Form1.GetDoctors();
loadDoctors();
}
else
{
MessageBox.Show("Cannot be empty...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch
{
MessageBox.Show("Something went wrong, does the doctor already exist? Please try again...", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// Update Account <acc> in database
public static bool update(Account acc)
{
using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
{
var query = from a in database.Accounts
// Assuming the accountNumber is enough of an identifier.
// Additional 'where' clauses can be added if necessary.
where (a.AccountID == acc.AccountID)
select a;
// It seems to me that a single account renders the foreach unnecessary. However, I can't
// find another way to get the variable 'a' from 'query'.
foreach (var a in query)
{
a.AccountAddress = acc.AccountAddress;
a.AccountFirstName = acc.AccountFirstName;
a.AccountLastName = acc.AccountLastName;
a.AccountNum = acc.AccountNum;
a.AccountPhoneNum = acc.AccountPhoneNum;
a.AccountRoutingNum = acc.AccountRoutingNum;
a.BankID = acc.BankID;
}
try
{
database.SubmitChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
categoryName = Request["category"];
productName = Request["product"];
using (var db = new DataClasses1DataContext())
{
if (categoryName == "野菜類")
{
var q = from x in db.YasaiKensa
where x.食品カテゴリ == categoryName.Normalize() && x.野菜品名 == productName.Normalize()
orderby x.採取日D descending
select x;
list = q.ToList();
}
else
{
var q = from x in db.YasaiKensa
where x.食品カテゴリ == categoryName.Normalize() && x.品目 == productName.Normalize()
orderby x.採取日D descending
select x;
list = q.ToList();
}
bqByDayImage.ImageUrl = String.Format("ProductChartImage.ashx?category={0}&product={1}", HttpUtility.UrlEncode(categoryName), HttpUtility.UrlEncode(productName));
prefImage.ImageUrl = list.PreparePrefURL(300,300);
}
Title = String.Format("{0}({1}) | 食品の放射能検査データ", productName, categoryName);
}
public P_fxrates[] GetLatestfxrates()
{
var db = new DataClasses1DataContext();
CultureInfo culture;
culture = new CultureInfo("en-Us", false);
var fxrates_update = GetfxratesLastUpdate();
string[] dt;
int? upd;
dt = fxrates_update[0].Day.Split('/');
upd = Convert.ToInt32(fxrates_update[0].Update);
int yyyy, mm, dd;
yyyy = Convert.ToInt32(dt[2]);
mm = Convert.ToInt32(dt[1]);
dd = Convert.ToInt32(dt[0]);
var datetime = new DateTime(yyyy, mm, dd);
var query = from temp in db.sp_Getfxrates(datetime, upd)
select new P_fxrates
{
ID = temp.ID.Value.ToString(),
Description = temp.Description,
BuyingRates = temp.BuyingRates,
SellingRates = temp.SellingRates,
SightBill = temp.SightBill,
Family = temp.Family.Trim(),
FamilyLong = temp.FamilyLong,
Bill_DD_TT = temp.Bill_DD_TT,
TT = temp.TT,
Update = temp.Update.Value.ToString(),
Ddate = temp.Date.Value.ToString("d/MM/yyyy", culture),
DTime = temp.Time
};
return query.ToArray();
}
// Update Store <store>
public static bool update(Store store)
{
using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
{
var query = from a in database.Stores
where (a.StoreID == store.StoreID)
select a;
foreach (var a in query)
{
a.StoreNum = store.StoreNum;
a.StoreName = store.StoreName;
a.StoreAddress = store.StoreAddress;
a.StoreServiceCharge = store.StoreServiceCharge;
}
try
{
database.SubmitChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public JsonResult habitacionesdisponibles(string fechai, string fechaf)
{
DataClasses1DataContext db = new DataClasses1DataContext();
string fii = fechai.Substring(3, 3) + fechai.Substring(0, 3) + fechai.Substring(6, 4);
string fnn = fechaf.Substring(3, 3) + fechaf.Substring(0, 3) + fechaf.Substring(6, 4);
DateTime fi = DateTime.Parse(fii), fn = DateTime.Parse(fnn);
var numero = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.numero.ToString())).ToArray();
var tipo = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.tip_hab.tipo)).ToArray();
var precio = (db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => (Convert.ToInt32(h.precio)).ToString())).ToArray();
var q = db.habitacions.Where(h => db.ocupado(h.numero, fi, fn).Value).Select(h => h.numero);
var ress = q.ToArray();
var rr = Json(ress);
int t = numero.Count();
string[,] cadena = new string[t, 3];
for (int i = 0; i < t; i++)
{
cadena[i, 0] = numero[i];
cadena[i, 1] = tipo[i];
cadena[i, 2] = precio[i];
}
var cad = Json(cadena);
return cad;
}
private void calcButton_Click(object sender, EventArgs e)
{
try
{
//Get input data from text boxes
int minStock = Convert.ToInt32(minStockBox.Text);
int maxStock = Convert.ToInt32(maxStockBox.Text);
int day = Convert.ToInt32(daysBox.Text);
int endDay = Convert.ToInt32(endDayBox.Text);
//testing of input data
if (minStock < 0 || maxStock < 0 || endDay < 1 || day < 1 || maxStock <= minStock)
throw new Exception("Invalid data");
//Calc Purchase table and parse function return
DataClasses1DataContext dc = new DataClasses1DataContext();
switch (dc.CalcMRP(1, endDay, minStock, day, maxStock))
{
case 1:
throw new Exception("StOck overflow");
case 2:
throw new Exception("Very little stock");
}
this.purchaseTableAdapter.Fill(this.assyPartDS.Purchase);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
DoctorEdit docEdit = new DoctorEdit();
if (!String.IsNullOrEmpty(doctorBox.Text))
{
DataClasses1DataContext editContext = new DataClasses1DataContext();
var doctor = (from doc in editContext.Doctors
where doc.doctorName == doctorBox.Text
select doc).First();
docEdit.oldDoctorName.Text = doctor.doctorName;
docEdit.oldInitials.Text = doctor.doctorID;
docEdit.oldGloves.Text = doctor.gloveSize.ToString();
docEdit.newDoctorName.Text = doctor.doctorName;
docEdit.newInitials.Text = doctor.doctorID;
docEdit.newGloves.Text = doctor.gloveSize.ToString();
docEdit.ShowDialog(this);
if (docEdit.DialogResult == DialogResult.OK)
{
Form1.DoctorsList.Clear();
Form1.GetDoctors();
loadDoctors();
}
}
else
{
MessageBox.Show("Please select a doctor from the list", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Index(ReservaHab model)
{
DataClasses1DataContext db = new DataClasses1DataContext();
reserva reserr = new reserva();
System.Guid id = System.Guid.Parse((System.Web.Security.Membership.GetUser(User.Identity.Name).ProviderUserKey).ToString());
reserr.idusuario = id;
var cliiii = 0;
if (model.tipocli2 == 1)
{
db.personas.Where(a => (a.cliente.nombre + " " + a.apellido).ToString() == model.buscarpersona.ToString()).Select(a => a.id).First();
}
if (model.tipocli2 == 2)
{
db.empresas.Where(a => a.cliente.nombre.ToString() == model.buscarempresa.ToString()).Select(a => a.id).First();
}
if (model.tipocli2 == 3)
{
db.agencias.Where(a => a.cliente.nombre.ToString() == model.buscaragencia.ToString()).Select(a => a.id).First();
}
reserr.idcli = cliiii;
reserr.idHab = model.idhab;
string ini = model.Fecha_I.Substring(3, 3) + model.Fecha_I.Substring(0, 3) + model.Fecha_I.Substring(6, 4);
string fin = model.Fecha_F.Substring(3, 3) + model.Fecha_F.Substring(0, 3) + model.Fecha_F.Substring(6, 4);
reserr.fecha_ini = DateTime.Parse(ini);
reserr.fecha_fin = DateTime.Parse(fin);
reserr.estado = "pendiente";
var ppago = db.habitacions.Where(a => a.numero == model.idhab).Select(a => a.precio).First();
reserr.pago = ppago * model.CantD;
db.reservas.InsertOnSubmit(reserr);
db.SubmitChanges();
return View();
}
// Update Check <check>
public static bool update(Check check)
{
using (DataClasses1DataContext database = new DataClasses1DataContext(Globals.connectionString))
{
var query = from a in database.Checks
where (a.CheckID == check.CheckID)
select a;
foreach (var a in query)
{
a.CheckAmount = check.CheckAmount;
a.CheckAmountOwed = check.CheckAmountOwed;
a.CheckCashierID = check.CheckCashierID;
a.CheckDate = check.CheckDate;
a.CheckDeleted = check.CheckDeleted;
a.CheckNum = check.CheckNum;
a.CheckPaidDate = check.CheckPaidDate;
}
try
{
database.SubmitChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public ActionResult upload(ArchivoFile datos)
{
string rutafisica = Server.MapPath("~/csv");
string rt = rutafisica + @"\" + datos.archivo.FileName;
datos.archivo.SaveAs(rutafisica + @"\" + datos.archivo.FileName);
DataClasses1DataContext db = new DataClasses1DataContext();
archivo ar = new archivo()
{
ruta_fisica = rutafisica + @"\" + datos.archivo.FileName,
fecha = DateTime.Now
};
db.archivos.InsertOnSubmit(ar);
db.SubmitChanges();
CsvReader csv = new CsvReader(new StreamReader(rt), true);
//int total = csv.FieldCount;
//string[] headers = csv.GetFieldHeaders;
List<reservasC> listares = new List<reservasC>();
while (csv.ReadNextRecord())
{
reservasC res = new reservasC()
{
nombreCliente = csv[0],
numHab = csv[1],
fechaI = csv[2],
fechaF = csv[3]
};
listares.Add(res);
}
ViewBag.lista = listares;
return View();
}
public void formFuncionario_Load(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var func = from funcionario in db.tblfuncionarios
select funcionario;
dgw_funcionario.DataSource = func ;
dgw_funcionario.Columns["id_funcionario"].HeaderText = "ID";
dgw_funcionario.Columns["nome"].HeaderText = "Nome ";
dgw_funcionario.Columns["sobrenome"].HeaderText = "Sobrenome";
dgw_funcionario.Columns["cpf"].HeaderText = "CPF";
dgw_funcionario.Columns["rg"].HeaderText = "RG";
dgw_funcionario.Columns["ctps"].HeaderText = "CTPS";
dgw_funcionario.Columns["data_admissao"].HeaderText = "Data Admissão";
dgw_funcionario.Columns["renumeracao_mensal"].HeaderText = "Renumeração Mensal";
dgw_funcionario.Columns["funcao"].HeaderText = "Função";
dgw_funcionario.Columns["endere"].HeaderText = "Endereço";
dgw_funcionario.Columns["bairro"].HeaderText = "Bairro";
dgw_funcionario.Columns["email"].HeaderText = "E-Mail";
dgw_funcionario.Columns["obs"].HeaderText = "Observação";
dgw_funcionario.Columns["sexo"].HeaderText = "Sexo";
// colocando nome nas coluna do datagrid
// barra rodape
toolStripStatusLabel1.Text = dgw_funcionario.RowCount + " Funcionários Cadastrado.";
}
private void btn_deletar_Click(object sender, EventArgs e)
{
try
{
// metodo para pega index dgw_funcionario.CurrentCell.RowIndex.ToString()
int selecionado = dgw_funcionario.CurrentCell.RowIndex;
int idfunc;
idfunc = int.Parse(dgw_funcionario.Rows[selecionado].Cells["id_funcionario"].Value.ToString());
DataClasses1DataContext db = new DataClasses1DataContext();
var funci = from funcionario in db.tblfuncionarios
where funcionario.id_funcionario.Equals(idfunc)
select funcionario;
tblfuncionario fun = funci.Single();
db.tblfuncionarios.DeleteOnSubmit(fun);
db.SubmitChanges();
MessageBox.Show("Deletado com sucesso");
Funcionarios.PreecherGridview(dgw_funcionario);
}
catch
{
MessageBox.Show("Ocorreu um erro!");
}
}
public static void FlowStatics()
{
System.IO.StreamWriter sw = new System.IO.StreamWriter("log.txt", false);
DataClasses1DataContext mydb = new DataClasses1DataContext(common.connString);
var message = mydb.LA_update1.Select(e => e.ip_version_MsgType).Distinct();
Dictionary<string, int> myDic = new Dictionary<string, int>();
foreach (string m in message)
{
myDic.Add(m, 0);
Console.Write(m + "--------------------");
Console.WriteLine(0);
sw.Write(m + "--------------------");
sw.WriteLine(0);
}
sw.Flush();
List<string> startmessage = new List<string>();
startmessage.Add("DTAP MM.Location Updating Request");
startmessage.Add("DTAP MM.CM Service Request");
startmessage.Add("DTAP RR.Paging Response");
startmessage.Add("BSSMAP.Handover Request");
foreach (var start in startmessage)
{
Dictionary<string, int> newDic = new Dictionary<string, int>();
foreach (KeyValuePair<string, int> pair in myDic)
newDic.Add(pair.Key, 0);
var a = from p in mydb.LA_update1
where p.ip_version_MsgType == start
select p.opcdpcsccp;
foreach (var b in a)
{
foreach (KeyValuePair<string, int> kvp in myDic)
{
var c = mydb.LA_update1.Where(e => e.opcdpcsccp == b).Where(e => e.ip_version_MsgType == kvp.Key).FirstOrDefault();
if (c != null)
newDic[kvp.Key] = newDic[kvp.Key] + 1;
}
}
foreach (var m in newDic.OrderByDescending(e => e.Value))
{
Console.Write(m.Key+"--------------------");
Console.WriteLine(m.Value);
sw.Write(m.Key + "--------------------");
sw.WriteLine(m.Value);
}
sw.Flush();
}
sw.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = new DataClasses1DataContext())
{
SRList = db.ShippingRestriction.ToList();
SRProducts= db.ShippingRestrictedProduct.ToList();
SRCities = db.ShippingRestrictedCity.ToList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Page.IsPostBack == false)
{
using (var db = new DataClasses1DataContext())
{
list = db.Temp_YasaiKensa.ToList();
}
}
}
protected void Publish_Click(object sender, EventArgs e)
{
using (var db = new DataClasses1DataContext())
{
db.ExecuteCommand("DELETE FROM YasaiKensa WHERE No IN (SELECT No FROM Temp_YasaiKensa);");
db.ExecuteCommand("INSERT INTO YasaiKensa SELECT * FROM Temp_YasaiKensa;");
db.ExecuteCommand("DELETE FROM Temp_YasaiKensa");
}
Response.Redirect("complete.aspx");
}
private void btnDeleteAll_Click(object sender, EventArgs e)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
if (DialogResult.Yes == MessageBox.Show("Delete all StreamMoments?", "Warning", MessageBoxButtons.YesNo))
{
logger.Info("Starting User requested StreamMoment wipe.");
dc.ExecuteCommand("Delete from StreamMoments");
logger.Info("Completed User requested StreamMoment wipe.");
}
}
static void checkIp()
{
DataClasses1DataContext database = new DataClasses1DataContext();
string ip = "176.9.103.131";
try
{
ip = VerifyIp();
int nrsecwait = 0;
while (ip.Contains("176.9.103.131"))//("89.33.106.3"))
{
Thread.Sleep(1000);
nrsecwait++;
if (nrsecwait % 10 == 0)
{
System.Console.WriteLine("VPN neconectat - " + DateTime.Now.ToString());
ip = VerifyIp();
//insereaza in tabel ip=ul
database.Insert_restartVPN_last_ip(ip);
}
//System.Console.WriteLine(nrsecwait);
if (nrsecwait > 30 && nrsecwait % 60 == 0)
{
#if DEBUG
System.Console.WriteLine("Se Face Restart La VPN - " + DateTime.Now.ToString());
// Process.Start("C:\\Users\\Adrian.Ghibaor\\Documents\\Visual Studio 2013\\Projects\\GetAgentie\\GetAgentie\\bin\\Release\\GetAgentie.exe");
#else
DateTime time = DateTime.Now;
System.Console.WriteLine("Se Face Restart La VPN - " + DateTime.Now.ToString());
Process.Start("script_vpn.exe");
Thread.Sleep(25000); // se asteapta 25 secunde pt ca si script_vpn are un sleep de 10 secunde pana face connnect si poate dura 10 secunde pana se conecteaza
System.Console.WriteLine("Acum ar trebui sa fie connectat - " + DateTime.Now.ToString());
#endif
ip = VerifyIp();
}
}
System.Console.WriteLine("VPN ok");
//inseereaza in tabel ip-ul
database.Insert_restartVPN_last_ip(ip);
}
catch (Exception e)
{
System.Console.WriteLine("Nu s-a putut verifica ip-ul, reincerc in 20 secunde - " + DateTime.Now.ToString());
//inseereaza in tabel ip-ul
database.Insert_restartVPN_last_ip(ip);
}
}
//public bool advanceUserInStudy(DataClasses1DataContext database, int SID, int UID)
public bool advanceUserInStudy(int SID, int UID)
{
DataClasses1DataContext database = new DataClasses1DataContext();
StudiesUser u = (from user in database.StudiesUsers
where user.StudyID == SID && user.UserID == UID
select user).Single();
//database.Refresh(refresh_mode, new Object[] {u, database.WordSublists, database.TrialTypes});
StudyUserGroup g = u.StudyUserGroup;
//database.Refresh(refresh_mode, g);
var subkeys = (from s in database.WordSublists
select s.ID);
var typekeys = (from s in database.TrialTypes
select s.ID);
int firstSublist = subkeys.Min();
int lastSublist = subkeys.Max();
int firstType = typekeys.Min();
int lastType = typekeys.Max();
if ((u.WordSublistID < lastSublist) && u.Mix)
{
u.WordSublistID++;
u.Mix = false;
}
else if (!u.Mix)
{
if (u.WordSublistID == firstSublist) //nothing to mix at the beginning
{
u.WordSublistID++;
}
else
{
u.Mix = true;
}
}
else if (u.TrialTypeID < lastType)
{
u.WordSublistID = firstSublist;
u.TrialTypeID++;
u.Mix = false;
}
else if (u.WordListID == g.FirstListID)
{
u.WordListID = g.SecondListID;
u.WordSublistID = firstSublist;
u.TrialTypeID = firstType;
}
else
{
u.Complete = true;
}
database.SubmitChanges();
return u.Complete;
}
private static User _getUser(string username, string pass)
{
DataClasses1DataContext dc1 = new DataClasses1DataContext();
var queryResult = (from user in dc1.GetTable<User>()
where (user.Username == username) &&
(user.Pass == pass)
select user).ToArray<User>();
if (queryResult.Count<User>() > 0)
return queryResult[0];
else return null;
}
public FormPesquisa()
{
InitializeComponent();
Banco = new DataClasses1DataContext();
// preechendo grid
PreecherGrid();
// alterando titulo do grid
AlterarHeadGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
var code = Request["code"];
using (var db = new DataClasses1DataContext())
{
SR = db.ShippingRestriction.Single(x => x.Code == code);
SRProducts = db.ShippingRestrictedProduct.Where(x => x.ShippingRestrictionCode == code).ToList();
SRCities = db.ShippingRestrictedCity.Where(x => x.ShippingRestrictionCode == code).ToList();
}
}
public ActionResult Index()
{
var students = new DataClasses1DataContext()
.CommonStudents
.Take(4)
.Select(x => x.FirstName + " " + x.LastName)
.ToList();
var model = new ListStudentsViewModel();
model.Students = students;
return View(model);
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = new DataClasses1DataContext())
{
var q = from x in db.YasaiKensa group x by x.食品カテゴリ into grp select new { name = grp.Key, count = grp.Count() };
categoryList = new Dictionary<string, int>();
foreach (var item in q.OrderByDescending(x => x.count))
{
categoryList.Add(item.name, item.count);
}
}
}
private static ZAST _getZast(string fname, string lname, string carnum)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
var queryResult = (from zast in dc.GetTable<ZAST>()
where (zast.FName == fname) &&
(zast.LName == lname) &&
(zast.CarNum == carnum)
select zast).ToArray<ZAST>();
if (queryResult.Count<ZAST>() > 0)
return queryResult[0];
else return null;
}
public QLDienKeController()
{
db = new DataClasses1DataContext();
}
private void btn_Print_Barcode_Click(object sender, EventArgs e)
{
try
{
dt_Kanban.Rows.Clear();
this.Cursor = Cursors.WaitCursor;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
// Step 1 delete UserName
var deleteItem = (from ii in db.TempPrintKanbans where ii.UserName == Environment.UserName select ii);
foreach (var d in deleteItem)
{
db.TempPrintKanbans.DeleteOnSubmit(d);
db.SubmitChanges();
}
// Step 2 Insert to Table
int c = 0;
string CodeNo = "";
radGridView1.EndEdit();
//insert
foreach (var Rowinfo in radGridView1.Rows)
{
if (StockControl.dbClss.TBo(Rowinfo.Cells["S"].Value).Equals(true))
{
CodeNo = StockControl.dbClss.TSt(Rowinfo.Cells["CodeNo"].Value);
var g = (from ix in db.tb_Items select ix).Where(a => a.CodeNo == CodeNo).ToList();
if (g.Count() > 0)
{
c += 1;
TempPrintKanban tm = new TempPrintKanban();
tm.UserName = Environment.UserName;
tm.CodeNo = g.FirstOrDefault().CodeNo;
tm.PartDescription = g.FirstOrDefault().ItemDescription;
tm.PartNo = g.FirstOrDefault().ItemNo;
tm.VendorName = g.FirstOrDefault().VendorItemName;
tm.ShelfNo = g.FirstOrDefault().ShelfNo;
tm.GroupType = g.FirstOrDefault().GroupCode;
tm.Max = Convert.ToDecimal(g.FirstOrDefault().MaximumStock);
tm.Min = Convert.ToDecimal(g.FirstOrDefault().MinimumStock);
tm.ReOrderPoint = Convert.ToDecimal(g.FirstOrDefault().ReOrderPoint);
tm.ToolLife = Convert.ToDecimal(g.FirstOrDefault().Toollife);
byte[] barcode = StockControl.dbClss.SaveQRCode2D(g.FirstOrDefault().CodeNo);
tm.BarCode = barcode;
db.TempPrintKanbans.InsertOnSubmit(tm);
db.SubmitChanges();
this.Cursor = Cursors.Default;
}
}
}
if (c > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = Environment.UserName;
Report.Reportx1.WReport = "001_Kanban_Part";
Report.Reportx1 op = new Report.Reportx1("001_Kanban_Part.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
this.Cursor = Cursors.Default;
}
public Partidos()
{
Db = new DataClasses1DataContext();
}
public static List <string> GetWojewodztwos()
{
DataClasses1DataContext db = new DataClasses1DataContext();
return(db.Wojewodztwos.OrderBy(x => x.Nazwa_Wojewodztwo).Select(x => x.Nazwa_Wojewodztwo).ToList());
}
public static List <string> GetStopienStudiows()
{
DataClasses1DataContext db = new DataClasses1DataContext();
return(db.StopienStudiows.Select(x => x.Stopien_Studiow_Nazwa).ToList());
}
public DateRangePurchases()
{
InitializeComponent();
context = new DataClasses1DataContext();
}
public SIGEEA_Moneda Moneda(int id)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
return(dc.SIGEEA_Monedas.FirstOrDefault(c => c.PK_Id_Moneda == id));
}
public FactPOSClass()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
/// <summary>
/// Obtiene la dirección de un empleado en específico a partir de su número de cédula
/// </summary>
/// <param name="cedula"></param>
/// <returns></returns>
public SIGEEA_spObtenerDireccionEmpleadoResult ObtenerDireccionEmpleado(string cedula)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
return(dc.SIGEEA_spObtenerDireccionEmpleado(cedula).First());
}
private void DataLoad()
{
//dt.Rows.Clear();
try
{
this.Cursor = Cursors.WaitCursor;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//dt = ClassLib.Classlib.LINQToDataTable(db.tb_Units.ToList());
try
{
// int year1 = 2017;
//var gd = (from ix in db.tb_ForcastCalculates
// where ix.MMM == dbClss.getMonth(cboMonth.Text) && ix.YYYY == year1
// select new { ix.YYYY, ix.MMM, Month = dbClss.getMonthRevest(ix.MMM)
// , ix.CodeNo
// , ItemDescription =db.tb_Items.Where(s => s.CodeNo == ix.CodeNo).Select(o => o.ItemDescription).FirstOrDefault()
// ,ix.ForeCastQty,ix.Toolife_spc,ix.SumQty,ix.ExtendQty,ix.UsePerDay,ix.LeadTime,ix.KeepStock,ix.AddErrQty,ix.OrderQty}).ToList();
var gd = (from a in db.tb_Items
select new {
CodeNo = a.CodeNo,
ItemDescription = a.ItemDescription,
Order = 10,
StockQty = 0,
BackOrder = 0,
UnitBuy = "PCS",
PCSUnit = 1,
LeadTime = a.Leadtime,
MaxStock = a.MaximumStock,
MinStock = a.MinimumStock,
VendorNo = "V0001",
VendorName = "HHL Interade Co.,LTD.",
CreateDate = DateTime.Now,
CreateBy = "Administrator",
Status = "รับเข้าแล้ว",
ItemName = a.ItemNo,
Delivery = DateTime.Now,
PRNo = "PR201705-0001",
ReceiveNo = "RC201705-001",
Cost = 1000
}).ToList();
//radGridView1.DataSource = gd;
//int rowcount = 0;
//foreach (var x in radGridView1.Rows)
//{
// rowcount += 1;
// x.Cells["dgvNo"].Value = rowcount;
// x.Cells["dgvCodeTemp"].Value = x.Cells["CodeNo"].Value.ToString();
// x.Cells["dgvCodeTemp2"].Value = x.Cells["VendorNo"].Value.ToString();
// //x.Cells["dgvCodeTemp3"].Value = x.Cells["MMM"].Value.ToString();
// // MessageBox.Show("ss");
// // x.Cells["ModelName"].ReadOnly = true;
// //x.Cells["YYYY"].ReadOnly = true;
// //x.Cells["MMM"].ReadOnly = true;
//}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
this.Cursor = Cursors.Default;
// radGridView1.DataSource = dt;
}
private void chartForm_Load(object sender, EventArgs e)
{
// SVE ZA RASPORED pictureBox
string[] sva_polja =
{
"a1b1", "a1b2", "a1b3", "a1b4", "a1b5", "a1b6",
"a2b1", "a2b2", "a2b3", "a2b4", "a2b5", "a2b6",
"a3b1", "a3b2", "a3b3", "a3b4", "a3b5", "a3b6",
"a4b1", "a4b2", "a4b3", "a4b4", "a4b5", "a4b6",
"a5b1", "a5b2", "a5b3", "a5b4", "a5b5", "a5b6",
"a6b1", "a6b2", "a6b3", "a6b4", "a6b5", "a6b6",
"a7b1", "a7b2", "a7b3", "a7b4", "a7b5", "a7b6",
"a8b1", "a8b2", "a8b3", "a8b4", "a8b5", "a8b6",
"a9b1", "a9b2", "a9b3", "a9b4", "a9b5", "a9b6",
"a10b1", "a10b2", "a10b3", "a10b4", "a10b5", "a10b6",
"a11b1", "a11b2", "a11b3", "a11b4", "a11b5", "a11b6",
"a12b1", "a12b2", "a12b3", "a12b4", "a12b5", "a12b6",
"a13b1", "a13b2", "a13b3", "a13b4", "a13b5", "a13b6"
};
int j = 0;
int k = 0;
int counter = 0;
int index = 0;
/*DataClasses3DataContext db3 = new DataClasses3DataContext();
* var varijabla1 = from s in db3.tblRasporeds select s.botunIme;
* string[] ime_botuna = varijabla1.ToArray();
* var varijabla2 = from s in db3.tblRasporeds select s.botunText;
* string[] text_botuna = varijabla2.ToArray(); */
DataClasses1DataContext db1 = new DataClasses1DataContext();
var varijabla1 = from s in db1.tblRasporeds select s.botunIme;
string[] ime_botuna = varijabla1.ToArray();
var varijabla2 = from s in db1.tblRasporeds select s.botunText;
string[] text_botuna = varijabla2.ToArray();
// za raspored
for (j = 0; j < sva_polja.Length; j++)
{
for (k = 0; k < text_botuna.Length; k++)
{
if (sva_polja[j] == ime_botuna[k])
{
counter++;
index = k;
}
}
if (counter > 0 && (text_botuna[index] == "Privatni trening" || text_botuna[index] == "Kickbox" || text_botuna[index] == "Kružni trening"))
{
trening_raspored++;
}
counter = 0;
index = 0;
}
//za vadenje podataka iz baze clanove-> LINQ
DataClasses2DataContext db2 = new DataClasses2DataContext();
var pomocna3 = from s in db2.tblMembers select s.spol;
string[] spol = pomocna3.ToArray();
var temp3 = from s in db2.tblMembers select s.vrsta_treninga;
string[] text = temp3.ToArray();
var varijabla3 = from s in db2.tblMembers select s.id;
int[] broj = varijabla3.ToArray();
int[] temp_niz = { 0, 0, 0 };
int[] spol_niz = { 0, 0 };
// za graf
for (int i = 0; i < text.Length; i++) // vadimo vrste treniga za chart2
{
if (text[i] == "Teretana")
{
temp_niz[0]++;
}
else if (text[i] == "Kickbox")
{
temp_niz[1]++;
}
else if (text[i] == "Kružni trening")
{
temp_niz[2]++;
}
else
{
continue;
}
}
for (int i = 0; i < text.Length; i++) // vadimo vrste ljudi za chart1
{
if (spol[i] == "Muški")
{
spol_niz[0]++;
}
else if (spol[i] == "Ženski")
{
spol_niz[1]++;
}
else
{
continue;
}
}
chart1.Series["s1"].IsValueShownAsLabel = true;
chart1.Series["s1"].Points.AddXY("1", spol_niz[0]); //ovo ce bit muski
chart1.Series["s1"].Points.AddXY("2", spol_niz[1]); // ovo zenski
chart1.Series["s1"].Points[0].LegendText = "Muškarci";
chart1.Series["s1"].Points[1].LegendText = "Žene";
chart2.Series["s2"].IsValueShownAsLabel = true;
chart2.Series["s2"].Points.AddXY("1", temp_niz[0]); //teretana
chart2.Series["s2"].Points.AddXY("2", temp_niz[1]); // kickbox
chart2.Series["s2"].Points.AddXY("3", temp_niz[2]); //kruzni trening
chart2.Series["s2"].Points[0].LegendText = "Teretana";
chart2.Series["s2"].Points[1].LegendText = "Kickbox";
chart2.Series["s2"].Points[2].LegendText = "Kružni trening";
}
public static Guid FindStupienStudiowIdByName(string name)
{
DataClasses1DataContext db = new DataClasses1DataContext();
return(db.StopienStudiows.Where(x => x.Stopien_Studiow_Nazwa == name).Select(x => x.Id_Stopien_Studiow).SingleOrDefault());
}
private void Save_detail2()
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
int id = 0;
int.TryParse(txtid.Text, out id);
if (id > 0)
{
string Type = "CNShipping";
string Category = "Invoice"; //Temp,Invoice
var g = (from ix in db.tb_Shippings
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.ShippingNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" &&
ix.id == Convert.ToInt32(txtid.Text)
select ix).First();
g.Status = "Cancel";
db.SubmitChanges();
//insert Stock
DateTime?CalDate = null;
DateTime?AppDate = DateTime.Now;
int Seq = 1;
//decimal Qty_Inv = 0;
//decimal Qty_DL = 0;
//decimal Qty_Remain = 0;
//decimal QTY = 0;
//decimal QTY_temp = 0;
//QTY = Convert.ToDecimal(g.QTY);
//QTY_temp = 0;
//Qty_Remain = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "", 0))); //sum ทั้งหมด
//Qty_Inv = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "Invoice", 0))); //sum เฉพาะ Invoice
//Qty_DL = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "Temp", 0))); // sum เฉพาะ DL
string Type_in_out = "In";
decimal RemainQty = 0;
decimal Amount = 0;
decimal RemainAmount = 0;
decimal Avg = 0;
decimal UnitCost = 0;
decimal sum_Remain = 0;
decimal sum_Qty = 0;
UnitCost = Convert.ToDecimal(g.UnitCost); //get_cost(g.CodeNo);
Amount = Convert.ToDecimal(txtQTY.Text) * UnitCost;
//แบบที่ 1 จะไป sum ใหม่
RemainQty = (Convert.ToDecimal(db.Cal_QTY(g.CodeNo, "", 0)));
//แบบที่ 2 จะไปดึงล่าสุดมา
//RemainQty = Convert.ToDecimal(dbClss.Get_Stock(vv.CodeNo, "", "", "RemainQty"));
sum_Remain = Convert.ToDecimal(dbClss.Get_Stock(g.CodeNo, "", "", "RemainAmount"))
+ Amount;
sum_Qty = RemainQty + Convert.ToDecimal(txtQTY.Text);
Avg = sum_Remain / sum_Qty;
RemainAmount = sum_Qty * Avg;
//กรณีที่ Shipping แบบ Temp แล้ว cancel ให้มาปรับ Flag ด้วย
var s1 = (from ix in db.tb_Stocks
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.RefNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" &&
ix.Refid == Convert.ToInt32(txtid.Text) &&
ix.Category == "Temp" &&
ix.Flag_ClearTemp == 1 &&
ix.Type == "Shipping"
select ix).ToList();
if (s1.Count > 0)
{
var s = (from ix in db.tb_Stocks
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.RefNo.Trim() == txtSHNo.Text.Trim() && ix.Status != "Cancel" &&
ix.Refid == Convert.ToInt32(txtid.Text) &&
ix.Category == "Temp" &&
ix.Flag_ClearTemp == 1 &&
ix.Type == "Shipping"
select ix).First();
if (s != null)
{
s.Flag_ClearTemp = 2;
db.SubmitChanges();
}
}
tb_Stock gg = new tb_Stock();
gg.AppDate = AppDate;
gg.Seq = Seq;
gg.App = "Cancel SH";
gg.Appid = Seq;
gg.CreateBy = ClassLib.Classlib.User;
gg.CreateDate = DateTime.Now;
gg.DocNo = txtCNNo.Text;
gg.RefNo = txtSHNo.Text;
gg.Type = ddlType.Text;
gg.CodeNo = txtCodeNo.Text.Trim();
gg.QTY = Convert.ToDecimal(txtQTY.Text);
gg.Inbound = Convert.ToDecimal(txtQTY.Text);
gg.Outbound = 0;
//gg.AmountCost = Convert.ToDecimal(txtQTY.Text) * get_cost(g.CodeNo);
//gg.UnitCost = get_cost(g.CodeNo);
//gg.RemainQty = 0;
//gg.RemainUnitCost = 0;
//gg.RemainAmount = 0;
gg.CalDate = CalDate;
gg.Status = "Active";
gg.Type_i = 4; //Receive = 1,Cancel Receive 2,Shipping = 3,Cancel Shipping = 4,Adjust stock = 5,ClearTemp = 6
gg.Category = Category;
gg.Refid = Convert.ToInt32(txtid.Text);
gg.Flag_ClearTemp = 0; //0 คือ invoice,1 คือ Temp , 2 คือ clear temp แล้ว
gg.Type_in_out = Type_in_out;
gg.AmountCost = Amount;
gg.UnitCost = UnitCost;
gg.RemainQty = sum_Qty;
gg.RemainUnitCost = 0;
gg.RemainAmount = RemainAmount;
gg.Avg = Avg;
db.tb_Stocks.InsertOnSubmit(gg);
db.SubmitChanges();
dbClss.AddHistory(this.Name, "เพิ่ม Stock", "Cancel รายการ Shipping [" + txtSHNo.Text.Trim() + " id : " + g.id.ToString() + " CodeNo : " + g.CodeNo + " จำนวน : " + txtQTY.Text + "]", txtCNNo.Text);
//update Stock เข้า item
db.sp_010_Update_StockItem(Convert.ToString(txtCodeNo.Text.Trim()), "");
//update Status
db.sp_007_Update_SH_Status(g.ShippingNo, Convert.ToString(g.id));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
db = new DataClasses1DataContext();
}
private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
radGridView1.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (var g in radGridView1.Rows)
{
if (!Convert.ToString(g.Cells["ModelName"].Value).Equals("")
)
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
//int yyyy = 0;
//int mmm = 0;
//decimal wk = 0;
//int.TryParse(Convert.ToString(g.Cells["YYYY"].Value), out yyyy);
//int.TryParse(Convert.ToString(g.Cells["MMM"].Value), out mmm);
//decimal.TryParse(Convert.ToString(g.Cells["WorkDays"].Value), out wk);
DateTime?d = null;
DateTime d1 = DateTime.Now;
if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals(""))
{
tb_Model u = new tb_Model();
u.ModelName = Convert.ToString(g.Cells["ModelName"].Value);
u.ModelDescription = Convert.ToString(g.Cells["ModelDescription"].Value);
u.ModelActive = Convert.ToBoolean(Convert.ToString(g.Cells["ModelActive"].Value));
u.LineName = Convert.ToString(g.Cells["LineName"].Value);
u.MCName = Convert.ToString(g.Cells["MCName"].Value);
u.Limit = Convert.ToBoolean(g.Cells["Limit"].Value);
if (DateTime.TryParse(Convert.ToString(g.Cells["ExpireDate"].Value), out d1))
{
d = dbClss.ChangeFormat(Convert.ToString(g.Cells["ExpireDate"].Value));
//Convert.ToDateTime(Convert.ToString(g.Cells["ExpireDate"].Value));
}
u.ExpireDate = d;
db.tb_Models.InsertOnSubmit(u);
db.SubmitChanges();
C += 1;
dbClss.AddHistory(this.Name, "เพิ่ม", "Insert Model [" + u.ModelName + "]", "");
}
else
{
var u = (from ix in db.tb_Models
where ix.ModelName == Convert.ToString(g.Cells["dgvCodeTemp"].Value)
select ix).First();
u.ModelDescription = Convert.ToString(g.Cells["ModelDescription"].Value);
u.ModelActive = Convert.ToBoolean(Convert.ToString(g.Cells["ModelActive"].Value));
u.LineName = Convert.ToString(g.Cells["LineName"].Value);
u.MCName = Convert.ToString(g.Cells["MCName"].Value);
u.Limit = Convert.ToBoolean(g.Cells["Limit"].Value);
if (DateTime.TryParse(Convert.ToString(g.Cells["ExpireDate"].Value), out d1))
{
d = dbClss.ChangeFormat(Convert.ToString(g.Cells["ExpireDate"].Value));
//Convert.ToDateTime(Convert.ToString(g.Cells["ExpireDate"].Value));
}
u.ExpireDate = d;
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "Update Model [" + u.ModelName + "]", "");
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("AddUnit", ex.Message, this.Name);
}
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
private void ImportData()
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (DataRow rd in dt.Rows)
{
if (!rd["ModelName"].ToString().Equals(""))
{
var x = (from ix in db.tb_Models where ix.ModelName == rd["ModelName"].ToString().Trim() select ix).FirstOrDefault();
DateTime?d = null;
DateTime d1 = DateTime.Now;
if (x == null)
{
tb_Model u = new tb_Model();
u.ModelName = rd["ModelName"].ToString().Trim();
u.ModelDescription = rd["ModelDescription"].ToString().Trim();
u.ModelActive = Convert.ToBoolean(rd["ModelActive"].ToString());
u.LineName = rd["LineName"].ToString().Trim();
u.MCName = rd["MCName"].ToString().Trim();
u.Limit = Convert.ToBoolean(rd["Limit"].ToString());
if (DateTime.TryParse(rd["ExpireDate"].ToString(), out d1))
{
u.ExpireDate = Convert.ToDateTime(rd["ExpireDate"].ToString());
}
else
{
u.ExpireDate = d;
}
db.tb_Models.InsertOnSubmit(u);
db.SubmitChanges();
}
else
{
x.ModelName = rd["ModelName"].ToString().Trim();
x.ModelDescription = rd["ModelDescription"].ToString().Trim();
x.ModelActive = Convert.ToBoolean(rd["ModelActive"].ToString());
x.LineName = rd["LineName"].ToString().Trim();
x.MCName = rd["MCName"].ToString().Trim();
x.Limit = Convert.ToBoolean(rd["Limit"].ToString());
if (DateTime.TryParse(rd["ExpireDate"].ToString(), out d1))
{
x.ExpireDate = Convert.ToDateTime(rd["ExpireDate"].ToString());
}
else
{
x.ExpireDate = d;
}
db.SubmitChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("InportData", ex.Message, this.Name);
}
}
/// <summary>
/// Obtiene la información del empleado a partir de su número de cédula
/// </summary>
/// <param name="pCedula"></param>
/// <returns></returns>
public SIGEEA_spObtenerEmpleadoResult AutenticaEmpleado(string pCedula)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
return(dc.SIGEEA_spObtenerEmpleado(pCedula).FirstOrDefault());
}
/// <summary>
/// The HomeController() function is used to create a new instance of the Database
/// context variable is a simple access to its data.
/// </summary>
public HomeController()
{
context = new DataClassAdminDataContext();
contextStudent = new DataClasses1DataContext();
}
/// <summary>
/// Realiza un listado de horas pendientes de pago de un empleado en específico
/// </summary>
/// <param name="pCedula"></param>
/// <returns></returns>
public List <SIGEEA_spObtenerPagosEmpleadosPendientesResult> ListarPagosEmpleados(string pCedula)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
return(dc.SIGEEA_spObtenerPagosEmpleadosPendientes(pCedula).ToList());
}
public ClsPrueba()
{
dbMapeo = new DataClasses1DataContext();
}
public double PrecioVenta(string id)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
return(dc.SIGEEA_spObtenerPrecioVentaMoneda(id).FirstOrDefault().PreVenta_Moneda);
}
public static Guid FindWojIdByNazwa(string nazwa)
{
DataClasses1DataContext db = new DataClasses1DataContext();
return(db.Wojewodztwos.Where(x => x.Nazwa_Wojewodztwo == nazwa).Select(x => x.Id_Wojewodztwo).SingleOrDefault());
}
private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
radGridView1.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (var g in radGridView1.Rows)
{
if (!Convert.ToString(g.Cells["YYYY"].Value).Equals("") &&
!Convert.ToString(g.Cells["MMM"].Value).Equals(""))
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
int yyyy = 0;
int mmm = 0;
decimal wk = 0;
int.TryParse(Convert.ToString(g.Cells["YYYY"].Value), out yyyy);
int.TryParse(Convert.ToString(g.Cells["MMM"].Value), out mmm);
decimal.TryParse(Convert.ToString(g.Cells["WorkDays"].Value), out wk);
if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals(""))
{
// MessageBox.Show("11");
if (yyyy > 0 && mmm > 0 && wk > 0)
{
tb_WorkDay u = new tb_WorkDay();
u.YYYY = yyyy;
u.MMM = mmm;
u.WorkDays = wk;
db.tb_WorkDays.InsertOnSubmit(u);
db.SubmitChanges();
C += 1;
dbClss.AddHistory(this.Name, "เพิ่ม", "Working Days [" + u.YYYY + "," + u.MMM + "]", "");
}
}
else
{
var unit1 = (from ix in db.tb_WorkDays
where ix.YYYY == Convert.ToInt32(g.Cells["dgvCodeTemp"].Value) &&
ix.MMM == Convert.ToInt32(g.Cells["dgvCodeTemp2"].Value)
select ix).First();
unit1.WorkDays = wk;
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "Update Working Days[" + unit1.YYYY + ", " + unit1.MMM + "]", "");
}
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError("AddUnit", ex.Message, this.Name); }
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
private bool AddUnit()
{
bool ck = false;
int C = 0;
try
{
radGridView1.EndEdit();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
foreach (var g in radGridView1.Rows)
{
if (!Convert.ToString(g.Cells["GroupCode"].Value).Equals("") &&
!Convert.ToString(g.Cells["TypeCode"].Value).Equals(""))
{
if (Convert.ToString(g.Cells["dgvC"].Value).Equals("T"))
{
if (Convert.ToString(g.Cells["dgvCodeTemp"].Value).Equals("") &&
Convert.ToString(g.Cells["dgvCodeTemp2"].Value).Equals("")
)
{
// MessageBox.Show("11");
tb_Type gy = new tb_Type();
gy.GroupCode = Convert.ToString(g.Cells["GroupCode"].Value);
gy.TypeCode = Convert.ToString(g.Cells["TypeCode"].Value);
gy.TypeActive = Convert.ToBoolean(g.Cells["TypeActive"].Value);
gy.TypeDetail = Convert.ToString(g.Cells["TypeDetail"].Value);
db.tb_Types.InsertOnSubmit(gy);
db.SubmitChanges();
C += 1;
dbClss.AddHistory(this.Name, "เพิ่มประเภท", "Insert Type Code [" + gy.TypeCode + "]", "");
}
else
{
var unit1 = (from ix in db.tb_Types
where ix.GroupCode == Convert.ToString(g.Cells["dgvCodeTemp"].Value) &&
ix.TypeCode == Convert.ToString(g.Cells["dgvCodeTemp2"].Value)
select ix).First();
unit1.TypeDetail = Convert.ToString(g.Cells["TypeDetail"].Value);
unit1.TypeActive = Convert.ToBoolean(g.Cells["TypeActive"].Value);
C += 1;
db.SubmitChanges();
dbClss.AddHistory(this.Name, "แก้ไข", "Update Type Code [" + unit1.TypeCode + "]", "");
}
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message);
dbClss.AddError("เพิ่มปรเภท", ex.Message, this.Name); }
if (C > 0)
{
MessageBox.Show("บันทึกสำเร็จ!");
}
return(ck);
}
public FormRegister(FormFirst form11)
{
InitializeComponent();
this.form11 = form11;
data = new DataClasses1DataContext();
}
private bool DeleteUnit()
{
bool ck = false;
int C = 0;
int m = 0;
try
{
if (row >= 0)
{
string CodeTemp = Convert.ToString(radGridView1.Rows[row].Cells["dgvCodetemp"].Value);
radGridView1.EndEdit();
if (MessageBox.Show("ต้องการลบรายการหรือไม่ ?", "ลบรายการ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
if (!CodeTemp.Equals(""))
{
//var unit1 = db.mh_Vendors.Where(x => x.No == CodeDelete).ToList();
//foreach (var d in unit1)
//{
// db.mh_Vendors.DeleteOnSubmit(d);
// dbClss.AddHistory(this.Name, "ลบผู้ขาย", "Delete Vendor [" + d.Name + "]", "");
//}
var t = db.mh_Shifts.Where(x => x.id == CodeTemp.ToInt()).ToList();
foreach (var d in t)
{
//db.mh_Routings.DeleteOnSubmit(d);
d.Active = false;
if (m == 0)
{
dbClss.AddHistory(this.Name, "ลบกะทำงาน", $"ลบกะทำงาน [{d.Description}]", "");
}
m++;
}
C += 1;
db.SubmitChanges();
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dbClss.AddError("ลบกะทำงาน", ex.Message, this.Name);
}
if (C > 0)
{
row = row - 1;
MessageBox.Show("ลบรายการ สำเร็จ!");
}
return(ck);
}
// GET: QLGiaDien
public QLGiaDienController()
{
db = new DataClasses1DataContext();
}
private void Save_detail2_H(int seq, int id, string SHNo, string CodeNo)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string Type = "CNShipping";
string Category = "Invoice"; //Temp,Invoice
string Type_in_out = "In";
decimal RemainQty = 0;
decimal Amount = 0;
decimal RemainAmount = 0;
decimal Avg = 0;
decimal UnitCost = 0;
decimal sum_Remain = 0;
decimal sum_Qty = 0;
decimal RemainUnitCost = 0;
string Location = "";
string ShelfNo = "";
var g = (from ix in db.tb_Shippings
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.ShippingNo.Trim() == SHNo.Trim() && ix.Status != "Cancel" &&
ix.id == id
select ix).First();
g.Status = "Cancel";
//insert Stock
DateTime?CalDate = null;
DateTime?AppDate = DateTime.Now;
int Seq = seq;
UnitCost = Convert.ToDecimal(g.UnitCost); //get_cost(g.CodeNo);
Amount = Convert.ToDecimal(g.QTY) * UnitCost;
//แบบที่ 1 จะไป sum ใหม่
RemainQty = (Convert.ToDecimal(db.Cal_QTY_Remain_Location(g.CodeNo, "", 0, dbClss.TSt(g.Location))));
//แบบที่ 2 จะไปดึงล่าสุดมา
//RemainQty = Convert.ToDecimal(dbClss.Get_Stock(vv.CodeNo, "", "", "RemainQty"));
sum_Remain = Convert.ToDecimal(dbClss.Get_Stock(g.CodeNo, "", "", "RemainAmount", dbClss.TSt(g.Location)))
+ Amount;
sum_Qty = RemainQty + Convert.ToDecimal(g.QTY);
//if (sum_Qty > 0)
// Avg = sum_Remain / sum_Qty;
//else
// Avg = 0;
RemainAmount = sum_Remain;//sum_Qty * Avg;
if (sum_Qty <= 0)
{
RemainUnitCost = 0;
}
else
{
RemainUnitCost = Math.Round((Math.Abs(RemainAmount) / Math.Abs(sum_Qty)), 2);
}
//กรณีที่ Shipping แบบ Temp แล้ว cancel ให้มาปรับ Flag ด้วย
var s1 = (from ix in db.tb_Stocks
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.DocNo.Trim() == SHNo.Trim() &&
ix.Status != "Cancel" &&
ix.CodeNo == CodeNo
//&& ix.Refid == id
//&& ix.Category == "Temp"
//&& ix.Flag_ClearTemp == 1
&& ix.Type == "Shipping"
select ix).ToList();
if (s1.Count > 0)
{
Location = dbClss.TSt(s1.FirstOrDefault().Location);
ShelfNo = dbClss.TSt(s1.FirstOrDefault().ShelfNo);
var ss = (from ix in db.tb_Stocks
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.DocNo.Trim() == SHNo.Trim() &&
ix.Status != "Cancel"
//&& ix.Refid == id
&& ix.CodeNo == CodeNo &&
ix.Category == "Temp" &&
ix.Flag_ClearTemp == 1 &&
ix.Type == "Shipping"
select ix).ToList();
if (ss.Count > 0)
{
var s = (from ix in db.tb_Stocks
//join i in db.tb_Items on ix.CodeNo equals i.CodeNo
where ix.DocNo.Trim() == SHNo.Trim() &&
ix.Status != "Cancel"
//&& ix.Refid == id
&& ix.CodeNo == CodeNo &&
ix.Category == "Temp" &&
ix.Flag_ClearTemp == 1 &&
ix.Type == "Shipping"
select ix).First();
if (s != null)
{
s.Flag_ClearTemp = 2;
db.SubmitChanges();
Location = dbClss.TSt(s.Location);
}
}
tb_Stock gg = new tb_Stock();
gg.AppDate = AppDate;
gg.Seq = Seq;
gg.App = "Cancel SH";
gg.Appid = Seq;
gg.CreateBy = ClassLib.Classlib.User;
gg.CreateDate = DateTime.Now;
gg.DocNo = txtCNNo.Text;
gg.RefNo = SHNo;
gg.Type = ddlType.Text;
gg.QTY = Convert.ToDecimal(g.QTY);
gg.Inbound = Convert.ToDecimal(g.QTY);
gg.Outbound = 0;
gg.CodeNo = g.CodeNo;
gg.Status = "Active";
gg.Type_i = 4; //Receive = 1,Cancel Receive 2,Shipping = 3,Cancel Shipping = 4,Adjust stock = 5,ClearTemp = 6
gg.Category = Category;
gg.Refid = dbClss.TInt(s1.FirstOrDefault().Refid); //Convert.ToInt32(txtid.Text);
gg.RefidAD = s1.FirstOrDefault().RefidAD;
//gg.RefShipid = id;
gg.Flag_ClearTemp = 0; //0 คือ invoice,1 คือ Temp , 2 คือ clear temp แล้ว
gg.Type_in_out = Type_in_out;
gg.AmountCost = Amount;
gg.UnitCost = UnitCost;
gg.RemainQty = sum_Qty;
gg.RemainUnitCost = RemainUnitCost;
gg.RemainAmount = RemainAmount;
gg.Avg = 0;// Avg;
gg.TLCost = Amount;
gg.TLQty = Convert.ToDecimal(g.QTY);
gg.ShipQty = 0;
gg.Location = Location;
gg.ShelfNo = ShelfNo;
gg.RefTempJobCode = dbClss.TSt(s1.FirstOrDefault().RefTempJobCode);
gg.RefJobCode = dbClss.TSt(s1.FirstOrDefault().RefJobCode);
gg.RefidJobCode = dbClss.TInt(s1.FirstOrDefault().RefidJobCode);
db.tb_Stocks.InsertOnSubmit(gg);
db.SubmitChanges();
dbClss.AddHistory(this.Name, "เพิ่ม Stock", "Cancel รายการ Shipping [" + txtSHNo.Text.Trim() + " id : " + g.id.ToString() + " CodeNo : " + g.CodeNo + " จำนวน : " + g.QTY.ToString() + "]", txtCNNo.Text);
//update Stock เข้า item
db.sp_010_Update_StockItem(Convert.ToString(g.CodeNo), "");
}
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
//Report.Reportx1.Value = new string[2];
//Report.Reportx1.Value[0] = ""; //BomNo
//Report.Reportx1.Value[1] = ClassLib.Classlib.User; //USERID
//Report.Reportx1.WReport = "TagFG";
//Report.Reportx1 op1 = new Report.Reportx1("FG_TAG.rpt");
//op1.Show();
this.Cursor = Cursors.WaitCursor;
try
{
if (dgvData.Rows.Where(x => x.Cells["S"].Value.ToBool()).Count() > 0)
{
var rowlist = dgvData.Rows.Where(x => x.Cells["S"].Value.ToBool()).ToList();
if (rowlist.Where(x => x.Cells["TagCount"].Value.ToDecimal() <= 0).Count() > 0)
{
baseClass.Warning("Tag cannot less than 1.");
return;
}
using (var db = new DataClasses1DataContext())
{
var l = db.mh_ProductTAGs.Where(x => x.UserID == ClassLib.Classlib.User).ToList();
db.mh_ProductTAGs.DeleteAllOnSubmit(l);
db.SubmitChanges();
//
int rNo = 0;
foreach (var row in rowlist)
{
string JobNo = row.Cells["JobNo"].Value.ToSt();
decimal Qty = row.Cells["Qty"].Value.ToDecimal();
string printDate = DateTime.Now.ToString("ddMMyyyy");
int TagCount = row.Cells["TagCount"].Value.ToInt();
decimal pkStd = row.Cells["PackingSTD"].Value.ToDecimal();
//decimal q1 = Math.Round(Qty / TagCount, 0);
//decimal q2 = Qty - Math.Round(q1 * (TagCount - 1), 0);
var t = Math.Round(Qty / pkStd, MidpointRounding.AwayFromZero);
if (t <= 0)
{
t = 1;
}
//var temp_tagCount = TagCount;
int ofTag = 0;
while (Qty > 0)
{
ofTag++;
rNo++;
var q1 = (Qty - pkStd > 0) ? pkStd : Qty;
string qr = $"{JobNo},{q1},{printDate},{ofTag}";
byte[] qrCode = dbClss.SaveQRCode2D(qr);
var m = new mh_ProductTAG
{
UserID = ClassLib.Classlib.User,
PartNo = row.Cells["ItemNo"].Value.ToSt(),
Seq = rNo,
PartName = row.Cells["ItemName"].Value.ToSt(),
LotNo = row.Cells["LotNo"].Value.ToSt(),
Qty = q1,
QRCode = qrCode,
Machine = "",
BOMNo = row.Cells["JobNo"].Value.ToSt(),
OFTAG = ofTag.ToSt(),
CustomerName = row.Cells["CstmName"].Value.ToSt(),
CSTMShot = row.Cells["CstmNo"].Value.ToSt(),
ProdDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date,
};
db.mh_ProductTAGs.InsertOnSubmit(m);
Qty -= pkStd;
}
//while (t > 0)
//{
// ofTag++;
// rNo++;
// bool last = temp_tagCount == 1;
// string qr = $"{JobNo},{((last) ? q2 : q1)},{printDate},{ofTag}";
// byte[] qrCode = dbClss.SaveQRCode2D(qr);
// var m = new mh_ProductTAG
// {
// UserID = ClassLib.Classlib.User,
// PartNo = row.Cells["ItemNo"].Value.ToSt(),
// Seq = rNo,
// PartName = row.Cells["ItemName"].Value.ToSt(),
// LotNo = row.Cells["LotNo"].Value.ToSt(),
// Qty = (last) ? q2 : q1,
// QRCode = qrCode,
// Machine = "",
// BOMNo = row.Cells["JobNo"].Value.ToSt(),
// OFTAG = ofTag.ToSt(),
// CustomerName = row.Cells["CstmName"].Value.ToSt(),
// CSTMShot = row.Cells["CstmNo"].Value.ToSt(),
// ProdDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date,
// };
// db.mh_ProductTAGs.InsertOnSubmit(m);
// temp_tagCount--;
//}
db.SubmitChanges();
//Save Production Date
DateTime ProductionDate = row.Cells["ProductionDate"].Value.ToDateTime().Value.Date;
var p = db.mh_ProductionOrders.Where(x => x.JobNo == JobNo).FirstOrDefault();
if (p != null)
{
p.ProductionDate = ProductionDate;
db.SubmitChanges();
}
}
if (rNo > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = ""; //BomNo
Report.Reportx1.Value[1] = ClassLib.Classlib.User; //USERID
Report.Reportx1.WReport = "TagFG";
Report.Reportx1 op = new Report.Reportx1("FG_TAG.rpt");
op.Show();
}
}
}
else
{
baseClass.Warning("Please select Data.\n");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { this.Cursor = Cursors.Default; }
}
public DanhSachDuocLenSoBo()
{
db = new DataClasses1DataContext();
}
