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));
}
