protected void btnsave_Click(object sender, EventArgs e)
{
string errmsg = string.Empty;
try
{
BALTransferIn objtransferin = new BALTransferIn();
Functions objfun = new Functions();
string meditem = string.Empty;
int ReviewCount = grdtransferinreview.Rows.Count;
if (ReviewCount != 0)
{
foreach (GridViewRow row in grdtransferinreview.Rows)
{
try
{
#region multi order generation start
objtransferin.TransferOutID = Convert.ToInt64(row.Cells[0].Text);
objtransferin.TransferNo = row.Cells[1].Text;
objtransferin.TransferOutDate = Convert.ToDateTime(row.Cells[2].Text);
objtransferin.CorporateIDfrom = Convert.ToInt64(row.Cells[3].Text);
objtransferin.CorporateIDTo = Convert.ToInt64(row.Cells[4].Text);
objtransferin.FacilityIDFrom = Convert.ToInt64(row.Cells[5].Text);
objtransferin.FacilityIDTo = Convert.ToInt64(row.Cells[6].Text);
objtransferin.FacilityFromName = row.Cells[7].Text;
objtransferin.ItemID = Convert.ToInt64(row.Cells[8].Text);
objtransferin.CategoryID = Convert.ToInt64(row.Cells[9].Text);
objtransferin.ItemDescription = HttpUtility.HtmlDecode(row.Cells[11].Text);
objtransferin.QtyPack = Convert.ToInt64(row.Cells[12].Text);
objtransferin.UOMID = Convert.ToInt64(row.Cells[13].Text);
string Price = row.Cells[15].Text;
string Subprice = Price.Substring(1);
objtransferin.Price = Convert.ToDecimal(Subprice);
//objtransferin.Price = Convert.ToDecimal(row.Cells[15].Text);
objtransferin.Transferqty = Convert.ToInt64(row.Cells[16].Text);
string TotalPrice = row.Cells[17].Text;
string SubTotalprice = TotalPrice.Substring(1);
objtransferin.TotalPrice = Convert.ToDecimal(SubTotalprice);
objtransferin.Status = row.Cells[19].Text;
objtransferin.LoggedinBy = defaultPage.UserId;
meditem = lclsservice.InsertTransferIn(objtransferin);
#endregion multi order generation end
}
catch (Exception innerce)
{
errmsg = errmsg + "Error in TransferID[" + objtransferin.TransferNo + "] - " + innerce.Message.ToString();
}
}
if (errmsg != string.Empty)
{
throw new Exception(errmsg);
}
if (meditem == "Saved Successfully")
{
BindGrid();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.TransferInSaveMsg.Replace("<<TransferInDescription>>", ""), true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.WarningTransferInNoRecord.Replace("<<TransferInDescription>>", ""), true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.TransferInErrorMessage.Replace("<<TransferInDescription>>", ex.Message), true);
}
}
public List <object> PrintTransferIn()
{
List <object> llstarg = new List <object>();
//List<BindTransferInReport> llstreview = lclsservice.BindTransferInReport(defaultPage.UserId).ToList();
BALTransferIn objbaltransferin = new BALTransferIn();
if (drpcorsearch.SelectedValue == "All")
{
objbaltransferin.ListCorporateID = "ALL";
}
else
{
foreach (ListItem lst in drpcorsearch.Items)
{
if (lst.Selected && drpcorsearch.SelectedValue != "All")
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListCorporateID = FinalString;
}
FinalString = "";
SB.Clear();
if (drpfacilitysearch.SelectedValue == "All")
{
objbaltransferin.ListFacilityID = "ALL";
}
else
{
foreach (ListItem lst in drpfacilitysearch.Items)
{
if (lst.Selected && drpfacilitysearch.SelectedValue != "All")
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListFacilityID = FinalString;
}
FinalString = "";
SB.Clear();
if (drpcategorysearch.SelectedValue == "All")
{
objbaltransferin.ListCategoryID = "ALL";
}
else
{
foreach (ListItem lst in drpcategorysearch.Items)
{
if (lst.Selected)
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListCategoryID = FinalString;
}
SB.Clear();
if (drpStatussearch.SelectedValue == "All")
{
objbaltransferin.Status = "ALL";
}
else
{
foreach (ListItem lst in drpStatussearch.Items)
{
if (lst.Selected)
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.Status = FinalString;
}
SB.Clear();
if (txtDateFrom.Text == "")
{
DateTime firstDayLastMonth = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(-1);
txtDateFrom.Text = firstDayLastMonth.ToString("MM/dd/yyyy");
}
else
{
objbaltransferin.DateFrom = Convert.ToDateTime(txtDateFrom.Text);
}
if (txtDateTo.Text == "")
{
txtDateTo.Text = DateTime.Now.ToString("MM/dd/yyyy");
}
else
{
objbaltransferin.DateTo = Convert.ToDateTime(txtDateTo.Text);
}
objbaltransferin.LoggedinBy = defaultPage.UserId;
List <SearchTransferIn> llstreview = lclsservice.SearchTransferIn(objbaltransferin).ToList();
rvTransferInReport.ProcessingMode = ProcessingMode.Local;
rvTransferInReport.LocalReport.ReportPath = Server.MapPath("~/Reports/TransferInSummary.rdlc");
ReportDataSource datasource = new ReportDataSource("TransferInSummaryDS", llstreview);
rvTransferInReport.LocalReport.DataSources.Clear();
rvTransferInReport.LocalReport.DataSources.Add(datasource);
rvTransferInReport.LocalReport.Refresh();
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytes = null;
bytes = rvTransferInReport.LocalReport.Render("PDF", "", out mimeType, out encoding, out extension, out streamids, out warnings);
llstarg.Insert(0, bytes);
return(llstarg);
}
public void BindGrid()
{
try
{
BALTransferIn objbaltransferin = new BALTransferIn();
if (drpcorsearch.SelectedValue == "All")
{
objbaltransferin.ListCorporateID = "ALL";
}
else
{
foreach (ListItem lst in drpcorsearch.Items)
{
if (lst.Selected && drpcorsearch.SelectedValue != "All")
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListCorporateID = FinalString;
}
FinalString = "";
SB.Clear();
if (drpfacilitysearch.SelectedValue == "All")
{
objbaltransferin.ListFacilityID = "ALL";
}
else
{
foreach (ListItem lst in drpfacilitysearch.Items)
{
if (lst.Selected && drpfacilitysearch.SelectedValue != "All")
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListFacilityID = FinalString;
}
FinalString = "";
SB.Clear();
if (drpcategorysearch.SelectedValue == "All")
{
objbaltransferin.ListCategoryID = "ALL";
}
else
{
foreach (ListItem lst in drpcategorysearch.Items)
{
if (lst.Selected)
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.ListCategoryID = FinalString;
}
SB.Clear();
if (drpStatussearch.SelectedValue == "All")
{
objbaltransferin.Status = "ALL";
}
else
{
foreach (ListItem lst in drpStatussearch.Items)
{
if (lst.Selected)
{
SB.Append(lst.Value + ',');
}
}
if (SB.Length > 0)
{
FinalString = SB.ToString().Substring(0, (SB.Length - 1));
}
objbaltransferin.Status = FinalString;
}
SB.Clear();
if (txtDateFrom.Text == "")
{
DateTime firstDayLastMonth = DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(-1);
txtDateFrom.Text = firstDayLastMonth.ToString("MM/dd/yyyy");
}
else
{
objbaltransferin.DateFrom = Convert.ToDateTime(txtDateFrom.Text);
}
if (txtDateTo.Text == "")
{
txtDateTo.Text = DateTime.Now.ToString("MM/dd/yyyy");
}
else
{
objbaltransferin.DateTo = Convert.ToDateTime(txtDateTo.Text);
}
objbaltransferin.LoggedinBy = defaultPage.UserId;
List <SearchTransferIn> lstTRIMaster = lclsservice.SearchTransferIn(objbaltransferin).ToList();
grdtransferinsearch.DataSource = lstTRIMaster;
grdtransferinsearch.DataBind();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", Constant.TransferInErrorMessage.Replace("<<TransferInDescription>>", ex.Message), true);
}
}