public async Task <ActionResult <PurchaseMaster> > PostPurchaseMaster(PurchaseMaster purchaseMaster)
{
_context.PurchaseMasters.Add(purchaseMaster);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetPurchaseMaster", new { id = purchaseMaster.ID }, purchaseMaster));
}
public async Task <IActionResult> PutPurchaseMaster(int id, PurchaseMaster purchaseMaster)
{
if (id != purchaseMaster.ID)
{
return(BadRequest());
}
_context.Entry(purchaseMaster).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
protected void btnget_Click(object sender, EventArgs e)
{
string FromDate1 = txtfromdate.Text.Split('/')[1] + "/" + txtfromdate.Text.Split('/')[0] + "/" + txtfromdate.Text.Split('/')[2];
string ToDate1 = txttodate.Text.Split('/')[1] + "/" + txttodate.Text.Split('/')[0] + "/" + txttodate.Text.Split('/')[2];
DateTime FromDate = Convert.ToDateTime(FromDate1);
DateTime ToDate = Convert.ToDateTime(ToDate1);
if (txtinvoice.Text.Trim() == "")
{
txtinvoice.Text = "0";
}
int InvoiceNo = Convert.ToInt32(txtinvoice.Text.Trim());
DataSet viewpurchase = new DataSet();
viewpurchase = PurchaseMaster.Get_PurchaseDetails(InvoiceNo, FromDate, ToDate);
if (viewpurchase.Tables[0].Rows.Count != 0)
{
grdpurchaseDetails.DataSource = viewpurchase;
grdpurchaseDetails.DataBind();
grdpurchaseDetails.Visible = true;
}
else
{
message("No Record found");
grdpurchaseDetails.Visible = true;
}
}
public ActionResult Test()
{
var poMaster = new PurchaseMaster
{
SupplierCode = "SUP001",
Date = DateTime.Now
};
dbContext.PurchaseMasters.Add(poMaster);
dbContext.PurchaseDetails.AddRange(new List <PurchaseDetail>
{
new PurchaseDetail {
Amount = 20, ItemCode = "Item001", ItemName = "Item 1", PONumber = poMaster.PONumber, Quantity = 2, Rate = 10
},
new PurchaseDetail {
Amount = 30, ItemCode = "Item002", ItemName = "Item 2", PONumber = poMaster.PONumber, Quantity = 3, Rate = 15
},
new PurchaseDetail {
Amount = 80, ItemCode = "Item003", ItemName = "Item 3", PONumber = poMaster.PONumber, Quantity = 4, Rate = 20
}
});
dbContext.SaveChanges();
return(Content("Test"));
}
private void btnPurchaseEntry_Click(object sender, EventArgs e)
{
PurchaseMaster pm = new PurchaseMaster(0);
pm.ShowDialog();
dataGridBind();
}
public IHttpActionResult CreatePurchaseMaster(PurchaseMaster purchasemaster)
{
var isSave = _purchaseMasterRepository.CreatePurchaseMaster(purchasemaster);
if (isSave == true)
{
return(Ok(isSave));
}
return(BadRequest());
}
public IHttpActionResult Update(PurchaseMaster purchasemaster, int?id)
{
var isupdate = _purchaseMasterRepository.UpdatePurchaseMaster(purchasemaster, id);
if (isupdate == true)
{
return(Ok(isupdate));
}
return(BadRequest());
}
public void fillData(bool callNew)
{
try
{
Report.Visible = true;
month = Convert.ToInt32(hidMonth.Value);
year = Convert.ToInt32(hidYear.Value);
if (Session["FY"] != null)
{
fyear = Convert.ToInt32(Session["FY"].ToString());
}
else
{
Session.Clear();
}
dt = new DataTable();
if (callNew == true)
{
dt = PurchaseMaster.Get_PurchaseDetails(0, System.DateTime.Now, System.DateTime.Now
, fyear, hidflag.Value, month, year).Tables[0];
ViewState["purstate"] = dt;
}
else
{
dt = (DataTable)ViewState["purstate"];
}
ReportDocument crystalReport = new ReportDocument();
if (hidflag.Value.ToLower() == "details" || hidflag.Value.ToLower() == "details_b" || hidflag.Value.ToLower() == "details_o")
{
if (hidflag.Value.ToLower() == "details_o")
{
crystalReport.Load(Server.MapPath("Report/Purchase_Details_Vat.rpt"));
}
else
{
crystalReport.Load(Server.MapPath("Report/Purchase_Details.rpt"));
}
}
else
{
crystalReport.Load(Server.MapPath("~/Report/Purchase_Summery.rpt"));
}
crystalReport.SetDataSource(dt);
crtcustomer.ReportSource = crystalReport;
}
catch (Exception ex)
{
}
}
protected void btnget_Click(object sender, EventArgs e)
{
try
{
string FromDate1 = "01/01/1999";
string ToDate1 = "03/31/2099";
if (txtfromdate.Text == "" || txttodate.Text == "")
{
FromDate1 = "01/01/1999";
ToDate1 = "03/31/2099";
}
else
{
FromDate1 = txtfromdate.Text.Split('/')[1] + "/" + txtfromdate.Text.Split('/')[0] + "/" + txtfromdate.Text.Split('/')[2];
ToDate1 = txttodate.Text.Split('/')[1] + "/" + txttodate.Text.Split('/')[0] + "/" + txttodate.Text.Split('/')[2];
}
DateTime FromDate = Convert.ToDateTime(FromDate1);
DateTime ToDate = Convert.ToDateTime(ToDate1);
if (txtinvoice.Text.Trim() == "")
{
txtinvoice.Text = "0";
}
int InvoiceNo = Convert.ToInt32(txtinvoice.Text.Trim());
DataTable dt = new DataTable();
dt = PurchaseMaster.Get_PurchaseDetails(InvoiceNo, FromDate, ToDate
, Convert.ToInt32(strFY), "ACINDIVIDUAL", 0, 0).Tables[0];
ReportDocument crystalReport = new ReportDocument();
if (dt.Rows.Count != 0)
{
crystalReport.Load(Server.MapPath("Report/Purchase_Details_Vat.rpt"));
crystalReport.SetDataSource(dt);
repPurchaseMasterView.ReportSource = crystalReport;
}
else
{
MessageBox("No Record found");
txtfromdate.Focus();
txtfromdate.Text = "";
txttodate.Text = "";
}
txtfromdate.Focus();
}
catch (Exception ex)
{
MessageBox(ex.Message + "(No Record found)");
}
}
public async Task <ActionResult> Put([FromBody] PurchaseMaster value)
{
try
{
var result = await purchaseMasterService.Update(value);
return(Ok(result));
}
catch (Exception)
{
return(BadRequest());
}
}
protected void BtnGetDCDetails_Click(object sender, EventArgs e)
{
//ModalPopUpDocNum.Hide();
//Session["tempDCData"] = null;
int DocNum = Convert.ToInt32(TxtDocNo.Text.Trim());
DataTable dt = new DataTable();
dt = PurchaseMaster.Get_PurchaseDetails(DocNum, Convert.ToDateTime("2011/01/01"), Convert.ToDateTime("2011/01/01")
, Convert.ToInt32(strFY), "ACEDIT", 0, 0).Tables[0];
if (dt.Rows.Count > 0)
{
lblshow.Text = dt.Rows[0]["SuppliersRef"].ToString();
txtSupplier.Text = dt.Rows[0]["SuppliersRefCode"].ToString();
txtPurchase.Text = dt.Rows[0]["PurchaseCode"].ToString();
lblpurchase.Text = dt.Rows[0]["PurchaseName"].ToString();
txtDate.Text = dt.Rows[0]["InvoiceDate"].ToString();
txtInvoiceNo.Text = dt.Rows[0]["InvoiceNo"].ToString();
lblID.Text = dt.Rows[0]["PurchaseMasterID"].ToString();
try
{
//txtPercentage.Text = dt.Rows[0]["vat"].ToString();
txtVatAmt.Text = dt.Rows[0]["vat"].ToString();
ddlmsoms.SelectedValue = dt.Rows[0]["ms_oms"].ToString();
ddlVat.SelectedValue = dt.Rows[0]["vat"].ToString();
txtremark.Text = dt.Rows[0]["remark"].ToString();
}
catch (Exception ex)
{
}
gvPurchasing.DataSource = dt;
gvPurchasing.DataBind();
Session["tempdata"] = dt;
btn_Save.Visible = true;
txtCode.Text = "MIS";
txtQuantity.Text = "1";
txtRate.Focus();
}
else
{
message("Record not found for document no. " + TxtDocNo.Text);
ModalPopUpDocNum.Show();
TxtDocNo.Text = "";
TxtDocNo.Focus();
btn_Save.Visible = false;
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
{
if (Session["UserName"] != null)
{
if (gvPurchasing.Rows.Count > 0)
{
PurchaseMaster pm = new PurchaseMaster();
pm.PurchaseMasterID = Convert.ToInt32(lblID.Text.Trim());
pm.PurchaseCode = txtPurchase.Text.Trim().ToString();
pm.PurchaseName = lblpurchase.Text.Trim().ToString();
pm.InvoiceNo = Convert.ToInt32(txtInvoiceNo.Text.Trim());
pm.SuppliersRef = lblshow.Text.Trim().ToString();
pm.SuppliersRefCode = txtSupplier.Text.Trim();
string date = txtDate.Text.Split('/')[1] + "/" + txtDate.Text.Split('/')[0] + "/" + txtDate.Text.Split('/')[2];
pm.InvoiceDate = Convert.ToDateTime(date);
//pm.SuppliersRefCode = txtRefCode.Text.Trim().ToString();
pm.IsActive = Convert.ToBoolean(true);
pm.CreatedBy = Session["UserName"].ToString() + "~" + txtInvAlfa.Text.Trim();
pm.FY = Convert.ToInt32(strFY);
pm.Oms = ddlmsoms.SelectedValue.ToString();
decimal vat = 0;
if (txtPercentage.Text == "")
{
vat = 0;
}
else
{
vat = Convert.ToDecimal(txtPercentage.Text.ToString());
}
pm.Ms = vat;
pm.Save(out DocNo, "");
SaveDetails(DocNo);
message("Record save successfully \\r\\n InvoiceNo:" + DocNo);
Session["tempdata"] = null;
gvPurchasing.DataBind();
txtDate.Text = "";
txtInvoiceNo.Text = "";
txtSupplier.Text = "";
txtPurchase.Text = "";
lblshow.Text = "";
lblpurchase.Text = "";
lblDescriptionofGoods.Text = "";
}
else
{
message("Enter Purchase Details");
}
}
}
}
public bool CreatePurchaseMaster(PurchaseMaster purchasemaster)
{
purchasemaster.PurchaseDate = now;
purchasemaster.CreatedDate = now;
purchasemaster.ModifiedDate = now;
int rowsAffected = this._db.Execute(@"INSERT PurchaseMaster(PurchaseDate,Status,IsActive,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate,Supplier_Id) values (@PurchaseDate,@Status,1,1,@CreatedDate,1,@ModifiedDate,@Supplier_Id)",
new { PurchaseDate = purchasemaster.PurchaseDate, Status = purchasemaster.Status, IsActive = 1, CreatedBy = 1, CreatedDate = purchasemaster.CreatedDate, ModifiedBy = 1, ModifiedDate = purchasemaster.ModifiedDate, Supplier_Id = purchasemaster.Supplier_Id });
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public bool UpdatePurchaseMaster(PurchaseMaster purchasemaster, int?id)
{
purchasemaster.ModifiedDate = now;
purchasemaster.PurchaseDate = now;
purchasemaster.CreatedDate = now;
int rowsAffected = this._db.Execute(
"UPDATE PurchaseMaster SET PurchaseDate= purchasemaster.PurchaseDate,Status = @Status,IsActive=1,CreatedBy=1,CreatedDate= purchasemaster.CreatedDate,ModifiedBy=1,ModifiedDate = purchasemaster.ModifiedDate,Supplier_Id=@Supplier_Id WHERE Id =" + id, purchasemaster);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
protected void txtInvoiceNo_TextChanged(object sender, EventArgs e)
{
int Invoice = Convert.ToInt32(txtInvoiceNo.Text.Trim());
bool Auth = PurchaseMaster.Idv_Chetana_Get_Validate_PurchaseInvoice(Invoice);
if (Auth)
{
MessageBox(" No. is Already Exist");
txtInvoiceNo.Text = "";
txtInvoiceNo.Focus();
}
else
{
txtSupplier.Focus();
}
}
private void dgPurchaseDetails_DoubleClick(object sender, EventArgs e)
{
try
{
if (dgPurchaseDetails.CurrentRow.Index != -1 && dgPurchaseDetails.CurrentRow.Cells[1].Value != null)
{
var lID = Convert.ToInt32(dgPurchaseDetails.CurrentRow.Cells[0].Value);
PurchaseMaster acc = new PurchaseMaster(lID);
acc.ShowDialog();
dataGridBind();
}
}
catch (Exception x)
{
MessageBox.Show("Something went wrong. Contact your system administrator");
}
}
protected void BtnGetDCDetails_Click(object sender, EventArgs e)
{
//ModalPopUpDocNum.Hide();
//Session["tempDCData"] = null;
int DocNum = Convert.ToInt32(TxtDocNo.Text.Trim());
Session["purDocNo"] = TxtDocNo.Text.Trim();
DataTable dt = new DataTable();
dt = PurchaseMaster.Get_PurchaseDetails(DocNum, Convert.ToDateTime("2011/01/01"), Convert.ToDateTime("2011/01/01")
, Convert.ToInt32(strFY), "EDIT", 0, 0).Tables[0];
if (dt.Rows.Count > 0)
{
lblshow.Text = dt.Rows[0]["SuppliersRef"].ToString();
txtSupplier.Text = dt.Rows[0]["SuppliersRefCode"].ToString();
txtPurchase.Text = dt.Rows[0]["PurchaseCode"].ToString();
lblpurchase.Text = dt.Rows[0]["PurchaseName"].ToString();
txtDate.Text = dt.Rows[0]["InvoiceDate"].ToString();
txtInvoiceNo.Text = dt.Rows[0]["InvoiceNo"].ToString();
lblID.Text = dt.Rows[0]["PurchaseMasterID"].ToString();
gvPurchasing.DataSource = dt;
gvPurchasing.DataBind();
Session["tempdata"] = dt;
}
else
{
message("Record not found for document no. " + TxtDocNo.Text);
ModalPopUpDocNum.Show();
TxtDocNo.Text = "";
TxtDocNo.Focus();
btn_Save.Visible = false;
}
}
protected void gvPurchasing_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
PurchaseDetails _objdcd = new PurchaseDetails();
purchaseDid = Convert.ToInt32(((Label)gvPurchasing.Rows[e.RowIndex].FindControl("lblpdetailid")).Text);
try
{
if (purchaseDid != 0)
{
_objdcd.PurchaseDetailId = purchaseDid;
_objdcd.IsActive = false;
_objdcd.Isdeleted = true;
_objdcd.Amount = 0;
_objdcd.Rate = 0;
_objdcd.Discount = 0;
_objdcd.Quantity = Convert.ToInt32(((TextBox)gvPurchasing.Rows[e.RowIndex].FindControl("lblQuantity")).Text);
_objdcd.UpdatedBy = Session["UserName"].ToString();
_objdcd.Delete();
}
DataTable dt1 = new DataTable();
string DocNumber;
DocNumber = Session["purDocNo"].ToString();
dt1 = PurchaseMaster.Get_PurchaseDetails(Convert.ToInt32(DocNumber), Convert.ToDateTime("2011/01/01"), Convert.ToDateTime("2011/01/01")
, Convert.ToInt32(strFY), "EDIT", 0, 0).Tables[0];
// dt1 = (DataTable)Session["tempdata"];
// dt1.Rows[e.RowIndex].Delete();
gvPurchasing.DataSource = dt1;
gvPurchasing.DataBind();
Session["tempdata"] = dt1;
}
catch
{
}
}
public void Update(PurchaseMaster purchaseMaster)
{
throw new NotImplementedException();
}
public void BindDashBoard(string flag)
{
gvPurchasingDashBoard.DataSource = PurchaseMaster.Get_PurchaseDetails(0, System.DateTime.Now, System.DateTime.Now
, Convert.ToInt32(strFY), flag, 0, 0);
gvPurchasingDashBoard.DataBind();
}
private void StockMaster_Click(object sender, RoutedEventArgs e)
{
PurchaseMaster purchaseMaster = new PurchaseMaster();
purchaseMaster.ShowDialog();
}
