public void TestSaveSupplierMng() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory); using (var db = new PurchaseEntities()) { SupplierMng supplier = db.SupplierMng.Find(0); // supplier.SupplierName = "供应商名称2"; supplier.SupplierMngAttachmentFile.Clear(); for (int i = 0; i < 2; i++) { SupplierMngAttachmentFile attach = new SupplierMngAttachmentFile(); attach.FileName = "fileName1"; attach.SeqNO = i + 1; attach.SupplierId = supplier.Id; attach.SupplierMng = supplier; attach.UploadChk = true; attach.InDateTime = DateTime.Now; attach.InUserId = "admin"; supplier.SupplierMngAttachmentFile.Add(attach); } db.SaveChanges(); } }
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { var identity = new ClaimsIdentity(context.Options.AuthenticationType); using (var db = new PurchaseEntities()) { if (db != null) { var user = db.Users.Where(o => o.UserName == context.UserName && o.Password == context.Password).FirstOrDefault(); if (user != null) { identity.AddClaim(new Claim("UserName", context.UserName)); identity.AddClaim(new Claim("LoggedOn", DateTime.Now.ToString())); context.Validated(identity); } else { context.SetError("Wrong Crendtials", "Provided username and password is incorrect"); context.Rejected(); } } else { context.SetError("Wrong Crendtials", "Provided username and password is incorrect"); context.Rejected(); } return; } }
public int BAaddPurchaseDetails(PurchaseEntities objPurchaseDetails) { DApurchaseMaster objPurchaseDA = new DApurchaseMaster(); int returnValue = objPurchaseDA.DAaddPurchaseDetails(objPurchaseDetails); return(returnValue); }
public bool SavePurchaseDetailsToDB(PurchaseEntities purchase, DataTable dt) { try { cmd = new SqlCommand("spInsertPurchaseDetails", conectn.ActiveCon()); cmd.Parameters.Add("@PurId", purchase.purchaseId); cmd.Parameters.Add("@PurDate", purchase.purcahseDate); cmd.Parameters.Add("@Pur_From", purchase.purchaseFrom); cmd.Parameters.Add("@Pur_Status", purchase.purchaseStatus); cmd.Parameters.AddWithValue("@SubDetails", dt); cmd.CommandType = CommandType.StoredProcedure; /////////////////////////////////////////////////////////////// //SqlParameter parameter = new SqlParameter("@SubDetails", SqlDbType.Structured); // parameter.Value = dt; int count = cmd.ExecuteNonQuery(); ////////////////////////////////////////////////////////////// return(true); } catch (Exception ex) { string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex); ErrorHandling.Class1.LogFileWrite(errorMessage); return(false); } finally { conectn.CloseCon(); } }
public int DA_ValidatePurchase(PurchaseEntities objPurchaseDetails) { int val = 0; DataTable dt = new DataTable(); try { con.Open(); MySqlCommand cmd = new MySqlCommand(objQuery.ValidatePurchase, con); cmd.Parameters.AddWithValue("@MobileNo", objPurchaseDetails.MobileNo); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); if (dt.Rows.Count > 0) { val = 1; } else { val = 0; } } catch (Exception ex) { ex.ToString(); //throw; } finally { con.Close(); } return(val); }
public ActionResult LoadChildHiddenCode(string type) { using (PurchaseEntities db = new PurchaseEntities()) { List <string> lst = db.HiddenCode.Where(x => x.UseChk.HasValue && x.UseChk.Value && x.Type == type).OrderBy(x => x.InDateTime).Select(x => x.Name).ToList(); lst.Insert(0, ""); return(Json(lst)); } }
protected void Button1_Click(object sender, EventArgs e) { int validate = 0; PurchaseEntities objPurchaseDetails = new PurchaseEntities(); try { objPurchaseDetails.PurchaseBillNo = Convert.ToInt32(PurchaseBillNo.Text); objPurchaseDetails.PurchaseDate = PurchaseDate.Text; objPurchaseDetails.VendorName = VendorName.Text; objPurchaseDetails.MobileNo = MobileNo.Text; objPurchaseDetails.EmailId = EmailId.Text; objPurchaseDetails.GSTNo = Convert.ToInt32(GSTNo.Text); objPurchaseDetails.CompanyName = Convert.ToString(CompanyName.Text); objPurchaseDetails.Product = (Product.SelectedItem.Value); objPurchaseDetails.Price = Convert.ToInt32(Price.Text); objPurchaseDetails.Quantity = Convert.ToInt32(Quantity.Text); objPurchaseDetails.GSTType = Convert.ToString(ddlGSTType.Text); objPurchaseDetails.GSTPercentage = Convert.ToInt16(GSTPercentage.Text); objPurchaseDetails.Total = Convert.ToInt16(Total.Text); objPurchaseDetails.Transport = Transport.Text; objPurchaseDetails.TotalAmount = Convert.ToInt32(TotalAmount.Text); objPurchaseDetails.Discount = Convert.ToInt32(Discount.Text); objPurchaseDetails.RupeesInWord = Convert.ToString(RupeesInWord.Text); objPurchaseDetails.PaymentMethod = Convert.ToString(PaymentMethod.Text); } catch (Exception ex) { ex.ToString(); } //BAL BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster(); validate = objPurchaseMasterBA.BA_ValidatePurchase(objPurchaseDetails); if (validate > 0) { Response.Write("<script> alert('Data already exist!')</script>"); } else { int rValue = objPurchaseMasterBA.BAaddPurchaseDetails(objPurchaseDetails); if (rValue > 0) { Response.Write("<script>alert('success')</script>"); GetTableDetails(); } else { Response.Write("<script>alert('Error')</script>"); } } }
public void TestQueryProjects() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);; using (var db = new PurchaseEntities()) { foreach (Projects project in db.Projects.ToList()) { Console.WriteLine(project.ProjectCode); } } }
public ActionResult ChangePassword(string sNewPassword) { using (PurchaseEntities db = new PurchaseEntities()) { Mst_UserInfo userInfo = db.Mst_UserInfo.Find(UserInfo.UserId); userInfo.Password = Utils.StrToMD5(sNewPassword); db.SaveChanges(); } Session["LoginUser"] = null; FormsAuthentication.SignOut(); return(Json(new { nAction = 2, sRedirectURL = "/Account/Login" })); }
public DataTable DA_ProductDetails(PurchaseEntities objPurchaseDetails) { QueryProcessor objQuery = new QueryProcessor(); con.Open(); MySqlCommand cmd = new MySqlCommand(objQuery.GetProductByName, con); cmd.Parameters.AddWithValue("@Product", objPurchaseDetails.Product); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); return(dt); }
public bool SavePurchaseDetails(PurchaseEntities purchase, DataTable dt) { IPurchaseDA purch; try { purch = new PurchaseDA(); return(purch.SavePurchaseDetailsToDB(purchase, dt)); } catch (Exception ex) { string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex); ErrorHandling.Class1.LogFileWrite(errorMessage); return(false); } }
public void SavePurchaseDetails() { purchasebl = new PurchaseBL(); try { purchase = new PurchaseEntities(); purchase.purchaseId = Convert.ToInt32(txtPurchaseId.Text); purchase.purchaseFrom = txtPurchaseFrom.Text; purchase.purcahseDate = Convert.ToDateTime(dtpPurchaseDate.Text); purchase.purchaseStatus = Convert.ToString(cmbStatus.Text) == "Active" ? 1 : 0; dt = new DataTable(); //dt.Columns.Add("SI No"); dt.Columns.Add("Pur_Id"); dt.Columns.Add("Pur_Date"); dt.Columns.Add("BookId"); dt.Columns.Add("BookName"); dt.Columns.Add("Quantity"); dt.Columns.Add("Rate"); dt.Columns.Add("Amount"); dt.Columns.Add("Status"); for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { dt.Rows.Add(); dt.Rows[i]["Pur_Id"] = purchase.purchaseId; //dt.Rows[i]["SI No"] = dataGridView1["SINo", i].Value; dt.Rows[i]["Pur_Date"] = purchase.purcahseDate; dt.Rows[i]["BookId"] = dataGridView1["BookId", i].Value; dt.Rows[i]["BookName"] = dataGridView1["BookName", i].Value; dt.Rows[i]["Quantity"] = dataGridView1["Qty", i].Value; dt.Rows[i]["Rate"] = dataGridView1["Rate", i].Value; dt.Rows[i]["Amount"] = dataGridView1["Amount", i].Value; dt.Rows[i]["Status"] = purchase.purchaseStatus; } purchasebl.SavePurchaseDetails(purchase, dt); } catch (Exception ex) { string errorMessage = ErrorHandling.Class1.CreateErrorMessage(ex); ErrorHandling.Class1.LogFileWrite(errorMessage); } }
public int DAaddPurchaseDetails(PurchaseEntities objPurchaseDetails) { int ReturnValue = 0; try { //con.Close(); con.Open(); MySqlCommand cmd = new MySqlCommand(objQuery.InsertPurchase, con); cmd.Parameters.AddWithValue("@PurchaseBillNo", objPurchaseDetails.PurchaseBillNo); cmd.Parameters.AddWithValue("@PurchaseDate", objPurchaseDetails.PurchaseDate); cmd.Parameters.AddWithValue("@VendorName", objPurchaseDetails.VendorName); cmd.Parameters.AddWithValue("@MobileNo", objPurchaseDetails.MobileNo); cmd.Parameters.AddWithValue("@EmailId", objPurchaseDetails.EmailId); cmd.Parameters.AddWithValue("@GSTNo", objPurchaseDetails.GSTNo); cmd.Parameters.AddWithValue("@CompanyName", objPurchaseDetails.CompanyName); cmd.Parameters.AddWithValue("@Product", objPurchaseDetails.Product); cmd.Parameters.AddWithValue("@Price", objPurchaseDetails.Price); cmd.Parameters.AddWithValue("@Quantity", objPurchaseDetails.Quantity); cmd.Parameters.AddWithValue("@GSTType", objPurchaseDetails.GSTType); cmd.Parameters.AddWithValue("@GSTPercentage", objPurchaseDetails.GSTPercentage); cmd.Parameters.AddWithValue("@Total", objPurchaseDetails.Total); cmd.Parameters.AddWithValue("@Transport", objPurchaseDetails.Transport); cmd.Parameters.AddWithValue("@TotalAmount", objPurchaseDetails.TotalAmount); cmd.Parameters.AddWithValue("@Discount", objPurchaseDetails.Discount); cmd.Parameters.AddWithValue("@RupeesInWord", objPurchaseDetails.RupeesInWord); cmd.Parameters.AddWithValue("@PaymentMethod", objPurchaseDetails.PaymentMethod); ReturnValue = cmd.ExecuteNonQuery(); } catch (Exception ex) { ex.ToString(); //throw } finally { con.Close(); } return(ReturnValue); }
protected void Product_SelectedIndexChanged(object sender, EventArgs e) { string product; DataTable dt = new DataTable(); PurchaseEntities objPurchaseDetails = new PurchaseEntities(); objPurchaseDetails.Product = Product.SelectedItem.Value; BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster(); dt = objPurchaseMasterBA.BA_GetProductDetails(objPurchaseDetails); foreach (DataRow dr in dt.Rows) { Price.Text = dr["SaleRate"].ToString(); GSTPercentage.Text = dr["GST"].ToString(); } }
public void TestMethod1() { AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);; using (var db = new PurchaseEntities()) { db.Projects.Add(new Projects { Id = 5, InUserId = "1", DepartmentCode = "DP", StartDate = DateTime.Now, EndDate = DateTime.Now, ExcuteType = "adsf", InDateTime = DateTime.Now, }); db.SaveChanges(); } }
protected void VendorName_TextChanged1(object sender, EventArgs e) { //string vendorname; DataTable dt = new DataTable(); PurchaseEntities objPurchaseDetails = new PurchaseEntities(); objPurchaseDetails.VendorName = VendorName.Text; BAPurchaseMaster objPurchaseMasterBA = new BAPurchaseMaster(); dt = objPurchaseMasterBA.BA_GetVendorDetails(objPurchaseDetails); foreach (DataRow dr in dt.Rows) { MobileNo.Text = dr["MobileNo"].ToString(); EmailId.Text = dr["EmailId"].ToString(); GSTNo.Text = dr["VendorGSTNo"].ToString(); CompanyName.Text = dr["CompanyName"].ToString(); } }
public static List <SelectListItem> MstUserList() { List <SelectListItem> lst = new List <SelectListItem>(); lst.Add(new SelectListItem() { Text = "", Value = "" }); using (PurchaseEntities db = new PurchaseEntities()) { foreach (Mst_UserInfo userinfo in db.Mst_UserInfo) { lst.Add(new SelectListItem() { Text = userinfo.UserName, Value = userinfo.UserId }); } } return(lst); }
public static List <SelectListItem> PositionList() { List <SelectListItem> lst = new List <SelectListItem>(); lst.Add(new SelectListItem() { Text = "", Value = "" }); using (PurchaseEntities db = new PurchaseEntities()) { foreach (Mst_Position position in db.Mst_Position) { lst.Add(new SelectListItem() { Text = position.PositionName, Value = position.PositionCode }); } } return(lst); }
public static List <SelectListItem> DeparmentList() { List <SelectListItem> lst = new List <SelectListItem>(); lst.Add(new SelectListItem() { Text = "", Value = "" }); using (PurchaseEntities db = new PurchaseEntities()) { foreach (Mst_Department department in db.Mst_Department) { lst.Add(new SelectListItem() { Text = department.DepartmentName, Value = department.DepartmentCode }); } } return(lst); }
public static List <SelectListItem> RoleTypeList() { List <SelectListItem> lst = new List <SelectListItem>(); lst.Add(new SelectListItem() { Text = "", Value = "" }); using (PurchaseEntities db = new PurchaseEntities()) { foreach (Mst_RoleType roleType in db.Mst_RoleType) { lst.Add(new SelectListItem() { Text = roleType.RoleTypeName, Value = roleType.RoleTypeCode }); } } return(lst); }
public HttpResponseMessage UpdatePurchases(PurchaseEntities model) { var Httpresponse = new HttpResponseMessage(); try { var id = GetEmployeeId(); if (!id.HasValue) { Httpresponse = new HttpResponseMessage(HttpStatusCode.Unauthorized); response.Code = HttpStatusCode.Unauthorized; response.Message = "Unauthorized"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } else { if (model == null) { Httpresponse = new HttpResponseMessage(HttpStatusCode.BadGateway); response.Code = HttpStatusCode.BadGateway; response.Message = "Bad Gateway"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } else { var purchase = context.Purchase.FirstOrDefault(x => x.State == ConstantHelper.Status.ACTIVE && x.PurchaseId == model.purchaseId); purchase.CodeGuide = model.codeGuide; purchase.LocalId = model.localId; purchase.PriceTotal = model.priceTotal; context.SaveChanges(); } Httpresponse = new HttpResponseMessage(HttpStatusCode.OK); response.Code = HttpStatusCode.OK; response.Message = "Success"; response.Result = null; } Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } catch { Httpresponse = new HttpResponseMessage(HttpStatusCode.BadGateway); response.Code = HttpStatusCode.BadGateway; response.Message = "Bad Gateway"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } }
public HttpResponseMessage AddPurchase(PurchaseEntities model) { var Httpresponse = new HttpResponseMessage(); try { var id = GetEmployeeId(); if (!id.HasValue) { Httpresponse = new HttpResponseMessage(HttpStatusCode.Unauthorized); response.Code = HttpStatusCode.Unauthorized; response.Message = "Unauthorized"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } else { var purchase = new Purchase(); if (model == null) { Httpresponse = new HttpResponseMessage(HttpStatusCode.BadGateway); response.Code = HttpStatusCode.BadGateway; response.Message = "Bad Gateway"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } else { context.Purchase.Add(purchase); purchase.DateCreation = DateTime.Today; purchase.CodeGuide = model.codeGuide; purchase.LocalId = model.localId; purchase.State = ConstantHelper.Status.ACTIVE; purchase.PriceTotal = model.priceTotal; purchase.ProviderId = model.providerId; purchase.CompanyId = model.companyId; context.SaveChanges(); } Httpresponse = new HttpResponseMessage(HttpStatusCode.OK); response.Code = HttpStatusCode.OK; response.Message = "Success"; response.Result = purchase; } Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } catch { Httpresponse = new HttpResponseMessage(HttpStatusCode.BadGateway); response.Code = HttpStatusCode.BadGateway; response.Message = "Bad Gateway"; response.Result = null; Httpresponse.Content = new StringContent(JsonConvert.SerializeObject(response)); Httpresponse.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(Httpresponse); } }
public void TestProject() { PurchaseEntities db = new PurchaseEntities(); Type t = typeof(RemindDto); List <RemindDto> list = db.Database.SqlQuery(t, "EXEC up_Remind_R").Cast <RemindDto>().ToList(); }
private void button2_Click(object sender, EventArgs e) { openFileDialog1.InitialDirectory = @"C:\Users\huohaitao\Desktop\导入需求书"; openFileDialog1.Multiselect = true; if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { using (var db = new PurchaseEntities()) { foreach (string filename in openFileDialog1.FileNames) { textBox1.Text = filename; MSExcelUtil msExcelUtil = new MSExcelUtil(); Workbook workbook = msExcelUtil.OpenExcelByMSExcel(filename); Worksheet sheet = workbook.ActiveSheet; int rowIndex = 2; string type = null; do { type = msExcelUtil.GetCellValue(sheet, 1, rowIndex); string content = msExcelUtil.GetCellValue(sheet, 2, rowIndex); string childChk = msExcelUtil.GetCellValue(sheet, 3, rowIndex); if (string.IsNullOrEmpty(content)) { continue; } string[] items = content.Split('/'); foreach (string item in items) { HiddenCode code = new HiddenCode(); code.Type = type.Trim(); code.Code = item.Trim(); code.Name = item.Trim(); if (item == "不限制" || item == "不涉及") { code.InDateTime = DateTime.MaxValue; } else { code.InDateTime = DateTime.Now; } code.InUserId = "sysadmin"; code.UseChk = true; if (db.HiddenCode.Find(type, item) == null) { db.HiddenCode.Add(code); } if (db.HiddenCodeType.Where(x => x.TypName == code.Type).Count() == 0) { db.HiddenCodeType.Add(new HiddenCodeType() { InDateTime = DateTime.Now, InUserId = "sysadmin", TypName = code.Type, ChildChk = string.IsNullOrEmpty(childChk) ? false : Convert.ToBoolean(childChk), }); db.SaveChanges(); } } rowIndex++; } while (!string.IsNullOrEmpty(type)); try { db.SaveChanges(); } catch (DbEntityValidationException dex) { MessageBox.Show(dex.Message); } MessageBox.Show("导入完成"); } } } }
public int BA_ValidatePurchase(PurchaseEntities objPurchasedetails) { DApurchaseMaster objPurchaseDA = new DApurchaseMaster(); return(objPurchaseDA.DA_ValidatePurchase(objPurchasedetails)); }
public DataTable BA_GetVendorDetails(PurchaseEntities objVendorDetails) { DApurchaseMaster objPurchaseDA = new DApurchaseMaster(); return(objPurchaseDA.DA_VendorDetails(objVendorDetails)); }
public DataTable BA_GetProductDetails(PurchaseEntities objProductDetails) { DApurchaseMaster objPurchaseDA = new DApurchaseMaster(); return(objPurchaseDA.DA_ProductDetails(objProductDetails)); }