private void GetBeginningInventory()
{
try
{
Image image_outlet = new Image();
image_outlet = (Image)gvOutlets.SelectedRow.FindControl("imgOutlet");
long customerNumber = long.Parse(image_outlet.AlternateText);
StoreOutStandingInventory SOI = SOIManager.IsHasSOIRecord(customerNumber);
if (SOI.RecordNumber != 0)
{
txtBeginningInventoryValue.Text = SOI.BeginningInventoryValue.ToString("###,###.00");
txtBeginningInventoryVolume.Text = SOI.BeginningInventoryVolume.ToString();
txtBeginningInventoryTotalCost.Text = SOI.BeginningInventoryTotalCost.ToString("###,###.00");
txtBeginningInventoryAvgCost.Text = SOI.BeginningInventoryAverageCost.ToString("###,###.00");
}
else
{
txtBeginningInventoryValue.Text = txtActualAccountValue.Text;
txtBeginningInventoryAvgCost.Text = txtActualAccountAvgCost.Text;
txtBeginningInventoryVolume.Text = txtActualAccountVolume.Text;
txtBeginningInventoryTotalCost.Text = txtActualAccountTotalCost.Text;
}
}
catch (Exception)
{
txtBeginningInventoryValue.Text = "0.00";
txtBeginningInventoryAvgCost.Text = "0.00";
txtBeginningInventoryVolume.Text = "0";
txtBeginningInventoryTotalCost.Text = "0.00";
}
}
public StoreOutStandingInventory IsHasRecordOnSOI(long CustNo, DateTime PeriodDate)
{
StoreOutStandingInventory SOI = new StoreOutStandingInventory();
try
{
SOI = GetBeginningOnSOI(CustNo, PeriodDate);
}
catch (Exception)
{
SOI = new StoreOutStandingInventory();
// ..throw;
}
return(SOI);
}
protected void btnSaveSOI_Click(object sender, EventArgs e)
{
Image image_outlet = new Image();
image_outlet = (Image)gvOutlets.SelectedRow.FindControl("imgOutlet");
StoreOutStandingInventory SOI_TO_SAVE = new StoreOutStandingInventory();
if (string.IsNullOrEmpty(txtActualAccountTotalCost.Text))
{
txtActualAccountTotalCost.Text = "0.00";
}
if (string.IsNullOrEmpty(txtActualAccountAvgCost.Text))
{
txtActualAccountAvgCost.Text = "0.00";
}
if (string.IsNullOrEmpty(txtActualAccountValue.Text))
{
txtActualAccountValue.Text = "0.00";
}
if (string.IsNullOrEmpty(txtActualAccountVolume.Text))
{
txtActualAccountVolume.Text = "0";
}
SOI_TO_SAVE.ActualCostTotalCost = decimal.Parse(txtActualAccountTotalCost.Text);
SOI_TO_SAVE.ActualCountAverageCost = decimal.Parse(txtActualAccountAvgCost.Text);
SOI_TO_SAVE.ActualCountValue = decimal.Parse(txtActualAccountValue.Text);
SOI_TO_SAVE.ActualCountVolume = decimal.Parse(txtActualAccountVolume.Text);
SOI_TO_SAVE.AdjustmentCreditAverageCost = decimal.Parse(txtCreditAvgCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.AdjustmentCreditTotalCost = decimal.Parse(txtCreditTotalCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.AdjustmentCreditValue = decimal.Parse(txtCreditValue.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.AdjustmentCreditVolume = decimal.Parse(txtCreditVolume.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.AdjustmentDebitAverageCost = decimal.Parse(txtDebitAvgCost.Text);
SOI_TO_SAVE.AdjustmentDebitTotalCost = decimal.Parse(txtDebitTotalCost.Text);
SOI_TO_SAVE.AdjustmentDebitValue = decimal.Parse(txtDebitValue.Text);
SOI_TO_SAVE.AdjustmentDebitVolume = decimal.Parse(txtDebitVolume.Text);
if (long.Parse(hfAdjustmentRecordNumber.Value) > 0)
{
SOI_TO_SAVE.AdjustmentRecordNumber = long.Parse(hfAdjustmentRecordNumber.Value);
}
else
{
SOI_TO_SAVE.AdjustmentRecordNumber = 0;
}
SOI_TO_SAVE.BeginningInventoryAverageCost = decimal.Parse(txtBeginningInventoryAvgCost.Text);
SOI_TO_SAVE.BeginningInventoryTotalCost = decimal.Parse(txtBeginningInventoryTotalCost.Text);
SOI_TO_SAVE.BeginningInventoryValue = decimal.Parse(txtBeginningInventoryValue.Text);
SOI_TO_SAVE.BeginningInventoryVolume = decimal.Parse(txtBeginningInventoryVolume.Text);
SOI_TO_SAVE.CustomerName = txtOutletName.Text;
SOI_TO_SAVE.CustomerNumber = int.Parse(image_outlet.AlternateText);
SOI_TO_SAVE.Brand = gvOutlets.SelectedRow.Cells[4].Text;
SOI_TO_SAVE.DateRecorded = DateTime.Now;
SOI_TO_SAVE.DeliveryAverageCost = decimal.Parse(txtDeliveryAvgCost.Text);
SOI_TO_SAVE.DeliveryTotalCost = decimal.Parse(txtdeliveryTotalCost.Text);
SOI_TO_SAVE.DeliveryValue = decimal.Parse(txtDeliveryValue.Text);
SOI_TO_SAVE.DeliveryVolume = decimal.Parse(txtDeliveryVolume.Text);
if (txtDiscrepancyTotalCost.Text.StartsWith("(") == false)
{
SOI_TO_SAVE.DiscrepancyTotalCost = decimal.Parse(txtDiscrepancyTotalCost.Text);
}
else
{
SOI_TO_SAVE.DiscrepancyTotalCost = decimal.Parse(txtDiscrepancyTotalCost.Text.Remove(0, 1).Replace(")", ""));
}
if (txtDiscrepancyValue.Text.StartsWith("(") == false)
{
SOI_TO_SAVE.DiscrepancyValue = decimal.Parse(txtDiscrepancyValue.Text);
}
else
{
SOI_TO_SAVE.DiscrepancyValue = decimal.Parse(txtDiscrepancyValue.Text.Remove(0, 1).Replace(")", ""));
}
if (txtDiscrepancyVolume.Text.StartsWith("(") == false)
{
SOI_TO_SAVE.DiscrepancyVolume = decimal.Parse(txtDiscrepancyVolume.Text);
}
else
{
SOI_TO_SAVE.DiscrepancyVolume = decimal.Parse(txtDiscrepancyVolume.Text.Remove(0, 1).Replace(")", ""));
}
SOI_TO_SAVE.EndingInventoryAverageCost = decimal.Parse(txtEndingInvventoryAvgCost.Text);
SOI_TO_SAVE.EndingInventoryTotalCost = decimal.Parse(txtEndingInvventoryTotalCost.Text);
SOI_TO_SAVE.EndingInventoryValue = decimal.Parse(txtEndingInvventoryValue.Text);
SOI_TO_SAVE.EndingInventoryVolume = decimal.Parse(txtEndingInvventoryVolume.Text);
SOI_TO_SAVE.GrossSalesAverageCost = decimal.Parse(txtGrossSalesAvgCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.GrossSalesTotalCost = decimal.Parse(txtGrossSalesTotalCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.GrossSalesValue = decimal.Parse(txtGrossSalesValue.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.GrossSalesVolume = decimal.Parse(txtGrossSalesVolume.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.PeriodFrom = DateTime.Parse(txtPeriodFrom.Text);
SOI_TO_SAVE.PeriodTo = DateTime.Parse(txtPeriodTo.Text);
SOI_TO_SAVE.ReturnsAverageCost = decimal.Parse(txtPullOutAvgCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.ReturnsTotalCost = decimal.Parse(txtPullOutTotalCost.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.ReturnsValue = decimal.Parse(txtPullOutValue.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.ReturnsVolume = decimal.Parse(txtPullOutVolume.Text.Remove(0, 1).Replace(")", ""));
SOI_TO_SAVE.TransactionDate = DateTime.Parse(txtTransactionDate.Text);
try
{
SOIManager.Save(SOI_TO_SAVE);
#region log
SOIManager.SaveTransactionLog(Permission.PERMITTED_USER, TransactionType.INSERT);
#endregion
}
catch (Exception)
{
// throw;
}
}
private void GetBeginningInventorySummary()
{
DataTable p_count_result = new DataTable();
try
{
List <SOI_BeginningInventory> SOI_BI;
Image image_outlet = new Image();
image_outlet = (Image)gvOutlets.SelectedRow.FindControl("imgOutlet");
long customerNumber = long.Parse(image_outlet.AlternateText);
StoreOutStandingInventory SOI = SOIManager.IsHasSOIRecord(long.Parse(image_outlet.AlternateText));
if (SOI != null)
{
txtBeginningInventoryValue.Text = SOI.ActualCountValue.ToString("###,###.00");
txtBeginningInventoryVolume.Text = SOI.ActualCountVolume.ToString();
txtBeginningInventoryTotalCost.Text = SOI.ActualCostTotalCost.ToString("###,###.00");
txtBeginningInventoryAvgCost.Text = SOI.ActualCountAverageCost.ToString("###,###.00");
SOI_BI = new List <SOI_BeginningInventory>();
SOI_BeginningInventory SOIBI = new SOI_BeginningInventory
{
Volume = decimal.Parse(txtBeginningInventoryVolume.Text),
Value = decimal.Parse(txtBeginningInventoryValue.Text),
AverageCost = decimal.Parse(txtBeginningInventoryAvgCost.Text),
TotalCost = decimal.Parse(txtActualAccountTotalCost.Text)
};
SOI_BI.Add(SOIBI);
gvSOIBI.DataSource = SOI_BI;
gvSOIBI.DataBind();
lblBIFrom.Text = "Beginning Inventory from Previous SOI";
}
else
{
List <SOI_BeginningInventory> SOI_PCOUNT = new List <SOI_BeginningInventory>();
DateTime dtPeriodFrom = new DateTime(DateTime.Parse(txtPeriodTo.Text).Year,
DateTime.Parse(txtPeriodFrom.Text).Month, 1);
DateTime dtPeriodToTemp = DateTime.Parse(txtPeriodFrom.Text);
DateTime dtPeriodTo = new DateTime(dtPeriodToTemp.Year, dtPeriodToTemp.Month,
DateTime.DaysInMonth(dtPeriodToTemp.Year, dtPeriodToTemp.Month));
if (dtPeriodToTemp.Month == 12 && dtPeriodToTemp.Day == 31) // ENDING YEAR
{
dtPeriodFrom = new DateTime(dtPeriodToTemp.Year + 1, 1, 1);
dtPeriodTo = new DateTime(dtPeriodToTemp.Year + 1, 1, DateTime.DaysInMonth(dtPeriodToTemp.Year, 1));
}
//DataTable physical_count = SOIManager.GetDataTableStoreOutStandingInventoryPhysiclCountSummary1(
// long.Parse(image_outlet.AlternateText), dtPeriodFrom, dtPeriodTo); year to year pick up change
DataTable physical_count = new DataTable();
if ((DateTime.Parse(txtPeriodTo.Text).Month - DateTime.Parse(txtPeriodFrom.Text).Month) == 11)
{
dtPeriodFrom = new DateTime(DateTime.Parse(txtPeriodFrom.Text).Year - 1, 12, 31);
physical_count = SOIManager.GetDataTableStoreOutStandingInventoryPhysiclCountSummary1(
customerNumber, dtPeriodFrom, dtPeriodTo);
}
else
{
physical_count = SOIManager.GetDataTableStoreOutStandingInventoryPhysiclCountSummary1(
customerNumber, dtPeriodFrom, dtPeriodTo);
}
if (physical_count.Rows.Count > 0)
{
p_count_result = physical_count;
}
else
{
dtPeriodFrom = new DateTime(dtPeriodFrom.Year - 1, 12, 1);
p_count_result = SOIManager.GetDataTableStoreOutStandingInventoryPhysiclCountSummary1(
customerNumber, dtPeriodFrom, dtPeriodTo);
}
foreach (DataRow row in p_count_result.Rows)
{
SOI_BeginningInventory PCOUNT = new SOI_BeginningInventory();
PCOUNT.Volume = decimal.Parse(row[1].ToString());
PCOUNT.Value = decimal.Parse(row[0].ToString());
PCOUNT.TotalCost = decimal.Parse(row[2].ToString());
PCOUNT.AverageCost = (decimal.Parse(row[2].ToString()) / decimal.Parse(row[1].ToString()));
SOI_PCOUNT.Add(PCOUNT);
}
SOI_BeginningInventory BI = SOI_PCOUNT[0];
if (SOI_PCOUNT.Count > 1)
{
SOI_BeginningInventory EI = SOI_PCOUNT[1];
hfPCountAveCost.Value = EI.AverageCost.ToString("###,###.00");
hfPcountTotalCost.Value = EI.TotalCost.ToString("###,###.00");
hfPCountValue.Value = EI.Value.ToString("###,###.00");
hfPCountVolume.Value = EI.Volume.ToString();
}
txtBeginningInventoryValue.Text = BI.Value.ToString("###,###.00");
txtBeginningInventoryVolume.Text = BI.Volume.ToString();
txtBeginningInventoryTotalCost.Text = BI.TotalCost.ToString("###,###.00");
txtBeginningInventoryAvgCost.Text = BI.AverageCost.ToString("###,###.00");
DataTable pcount_breakdown = SOIManager.GetDataTableStoreOutStandingInventoryPhysicalCountBreakdown(
long.Parse(image_outlet.AlternateText), DateTime.Parse(txtPeriodFrom.Text));
gvSOIBI.DataSource = pcount_breakdown;
gvSOIBI.DataBind();
lblBIFrom.Text = "Beginning Inventory from Bridge Table";
}
}
catch (Exception)
{
txtBeginningInventoryValue.Text = "0.00";
txtBeginningInventoryVolume.Text = "0";
this.txtBeginningInventoryTotalCost.Text = "0.00";
txtBeginningInventoryAvgCost.Text = "0.00";
}
}
public void GetSoiDetails(StoreOutStandingInventory SOI)
{
txtActualAccountAvgCost.Text = SOI.ActualCountAverageCost.ToString("###,###.00");
txtActualAccountTotalCost.Text = SOI.ActualCostTotalCost.ToString("###,###.00");
txtActualAccountValue.Text = SOI.ActualCountValue.ToString("###,###.00");
if (SOI.ActualCountVolume != 0)
{
txtActualAccountVolume.Text = SOI.ActualCountVolume.ToString("###,###");
}
else
{
txtActualAccountVolume.Text = "(0)";
}
txtBeginningInventoryAvgCost.Text = SOI.BeginningInventoryAverageCost.ToString("###,###.00");
txtBeginningInventoryTotalCost.Text = SOI.BeginningInventoryTotalCost.ToString("###,###.00");
txtBeginningInventoryValue.Text = SOI.BeginningInventoryValue.ToString("###,###.00");
if (SOI.BeginningInventoryVolume != 0)
{
txtBeginningInventoryVolume.Text = SOI.BeginningInventoryVolume.ToString("###,###");
}
else
{
txtBeginningInventoryVolume.Text = "(0)";
}
txtCreditAvgCost.Text = SOI.AdjustmentCreditAverageCost.ToString("(###,###.00)");
txtCreditTotalCost.Text = SOI.AdjustmentCreditTotalCost.ToString("(###,###.00)");
txtCreditValue.Text = SOI.AdjustmentCreditValue.ToString("(###,###.00)");
if (SOI.AdjustmentCreditVolume != 0)
{
txtCreditVolume.Text = SOI.AdjustmentCreditVolume.ToString("(###,###)");
}
else
{
txtCreditVolume.Text = "(0)";
}
txtDebitAvgCost.Text = SOI.AdjustmentDebitAverageCost.ToString("###,###.00");
txtDebitTotalCost.Text = SOI.AdjustmentDebitTotalCost.ToString("###,###.00");
txtDebitValue.Text = SOI.AdjustmentDebitValue.ToString("###,###.00");
if (SOI.AdjustmentDebitVolume != 0)
{
txtDebitVolume.Text = SOI.AdjustmentDebitVolume.ToString("###,###");
}
else
{
txtDebitVolume.Text = "0";
}
txtDeliveryAvgCost.Text = SOI.DeliveryAverageCost.ToString("###,###.00");
txtdeliveryTotalCost.Text = SOI.DeliveryTotalCost.ToString("###,###.00");
txtDeliveryValue.Text = SOI.DeliveryValue.ToString("###,###.00");
if (SOI.DeliveryVolume != 0)
{
txtDeliveryVolume.Text = SOI.DeliveryVolume.ToString("###,###");
}
else
{
txtDeliveryVolume.Text = "(0)";
}
if (SOI.DiscrepancyTotalCost <= 0)
{
txtDiscrepancyTotalCost.Text = (-1 * SOI.DiscrepancyTotalCost).ToString("(###,###.00)");
}
else
{
txtDiscrepancyTotalCost.Text = (SOI.DiscrepancyTotalCost).ToString("###,###.00");
}
if (SOI.DiscrepancyVolume <= 0)
{
txtDiscrepancyVolume.Text = (-1 * SOI.DiscrepancyVolume).ToString("(###,###)");
}
else
{
txtDiscrepancyVolume.Text = (SOI.DiscrepancyVolume).ToString("(###,###)");
}
if (SOI.DiscrepancyValue <= 0)
{
txtDiscrepancyValue.Text = (-1 * SOI.DiscrepancyValue).ToString("(###,###.00)");
}
else
{
txtDiscrepancyValue.Text = (SOI.DiscrepancyValue).ToString("###,###.00");
}
txtEndingInvventoryAvgCost.Text = SOI.EndingInventoryAverageCost.ToString("###,###.00");
txtEndingInvventoryTotalCost.Text = SOI.EndingInventoryTotalCost.ToString("###,###.00");
txtEndingInvventoryValue.Text = SOI.EndingInventoryValue.ToString("###,###.00");
if (SOI.EndingInventoryVolume != 0)
{
txtEndingInvventoryVolume.Text = SOI.EndingInventoryVolume.ToString("###,###");
}
else
{
txtEndingInvventoryVolume.Text = "(0)";
}
txtGrossSalesAvgCost.Text = SOI.GrossSalesAverageCost.ToString("(###,###.00)");
txtGrossSalesTotalCost.Text = SOI.GrossSalesTotalCost.ToString("(###,###.00)");
txtGrossSalesValue.Text = SOI.GrossSalesValue.ToString("(###,###.00)");
if (SOI.GrossSalesVolume != 0)
{
txtGrossSalesVolume.Text = SOI.GrossSalesVolume.ToString("(###,###)");
}
else
{
txtGrossSalesVolume.Text = "(0)";
}
txtOutletName.Text = SOI.CustomerName;
txtPeriodFrom.Text = SOI.PeriodFrom.ToString("MMMM dd, yyyy");
txtPeriodTo.Text = SOI.PeriodTo.ToString("MMMM dd, yyyy");
txtPullOutAvgCost.Text = SOI.ReturnsAverageCost.ToString("(###,###.00)");
txtPullOutTotalCost.Text = SOI.ReturnsTotalCost.ToString("(###,###.00)");
txtPullOutValue.Text = SOI.ReturnsValue.ToString("(###,###.00)");
if (SOI.ReturnsVolume != 0)
{
txtPullOutVolume.Text = SOI.ReturnsVolume.ToString("(###,###)");
}
else
{
txtPullOutVolume.Text = "(0)";
}
txtTransactionDate.Text = SOI.TransactionDate.ToString("MMMM dd, yyyy");
lblCustomerNameToDelete.Text = "SOI FOR: " + SOI.CustomerName;
lblDateFromToToDelete.Text = "PERIOD FROM: " + SOI.PeriodFrom.ToString("MMMM dd, yyyy") + " TO " + SOI.PeriodTo.ToString("MMMM dd, yyyy");
}
private void Acc_StockCardQrt()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString);
ReportDocument rpt;
string rptDocCachedKey = null;
rptDocCachedKey = "rptStockCardQrt";
if (Cache[rptDocCachedKey] != null)
{
rpt = (StockCardRptQuarterly)Cache[rptDocCachedKey];
}
else
{
rpt = new StockCardRptQuarterly();
Cache.Insert(rptDocCachedKey, rpt);
}
long CustNo = long.Parse(Request.QueryString["custno"]);
DateTime PrevDate = DateTime.Parse(Request.QueryString["datefrom"]).AddDays(-1);
DateTime DateFrom = DateTime.Parse(Request.QueryString["datefrom"]);
DateTime DateTo = DateTime.Parse(Request.QueryString["dateto"]);
long Balqty = 0;
decimal Balamt = 0;
decimal Balcost = 0;
long Balqty1 = 0;
decimal Balamt1 = 0;
decimal Balcost1 = 0;
long Debitqty = 0;
decimal Debitamt = 0;
decimal Debitcost = 0;
long Creditqty = 0;
decimal Creditamt = 0;
decimal Creditcost = 0;
bool Firstrec = true;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 300;
cmd.CommandText = "delete from RptStockCardQrt where username='******'";
cmd.ExecuteNonQuery();
StockCardReportManager SCRManager = new StockCardReportManager();
StoreOutStandingInventory SOIBeginning = SCRManager.IsHasRecordOnSOI(CustNo, PrevDate);
if (SOIBeginning != null)
{
cmd.CommandTimeout = 300;
cmd.CommandText = "GenRptStockCard_Beg_SOI_Qrt '" + DateFrom + "', '" + DateTo + "', '" + PrevDate + "', " + CustNo + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandTimeout = 300;
cmd.CommandText = "GenRptStockCard_Beg_Pcount_Qrt '" + DateFrom + "', '" + DateTo + "', " + CustNo + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
//cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "genrptstockcardqrt '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
DataTable ResultSet = new DataTable();
cmd.CommandText = "genrptstockcardqrtsales '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "select * from RptStockCardQrt where custno = " + Request.QueryString["custno"] + " and datefrom= '" + Request.QueryString["datefrom"] + "' and dateto='" + Request.QueryString["dateto"] + "'";
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
adapter.SelectCommand = cmd;
adapter.Fill(ResultSet);
}
foreach (DataRow row in ResultSet.Rows)
{
if (Firstrec == true)
{
Balqty = Convert.ToInt64(row[14]);
Balamt = ConvertDataToDecimal(row[15]);
Balcost = ConvertDataToDecimal(row[16]);
Firstrec = false;
}
else
{
Debitqty = Convert.ToInt64(row[8]);
Debitamt = ConvertDataToDecimal(row[9]);
Debitcost = ConvertDataToDecimal(row[10]);
Creditqty = Convert.ToInt64(row[11]);
Creditamt = ConvertDataToDecimal(row[12]);
Creditcost = ConvertDataToDecimal(row[13]);
Balqty1 = Balqty + Debitqty + Creditqty;
Balamt1 = Balamt + Debitamt + Creditamt;
Balcost1 = Balcost + Debitcost + Creditcost;
Balqty = Balqty1;
Balamt = Balamt1;
Balcost = Balcost1;
cmd.CommandText = "update RptStockCardQrt set balance_qty = " + Balqty + ", balance_amt = " + Balamt + ", balance_cost= " + Balcost + " where id = " + (long)row[0] + " and custno = " + (int)row[4] + " and username = '******' and datefrom = '" + DateFrom + "' and dateto = '" + DateTo + "'";
cmd.ExecuteNonQuery();
}
}
DataBaseLogIn(rpt);
ParameterField prmDatefrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterField prmCustno = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDatefrom.ParameterFieldName = "datefrom";
prmDateTo.ParameterFieldName = "dateto";
prmCustno.ParameterFieldName = "custno";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmCustnoValue = new ParameterDiscreteValue();
prmDateFromValue.Value = Request.QueryString["datefrom"];
prmDateToValue.Value = Request.QueryString["dateto"];
prmCustnoValue.Value = Request.QueryString["custno"];
prmDatefrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmCustno.CurrentValues.Add(prmCustnoValue);
prmList.Add(prmDatefrom);
prmList.Add(prmDateTo);
prmList.Add(prmCustno);
crvDailyReport.ParameterFieldInfo = prmList;
crvDailyReport.ReportSource = rpt;
}
private void PreviewSOI(long RecordNumber)
{
StoreOutStandingInventory SOI = SOIManager.GetStoreOutStandingInventoryByRecordNumber(RecordNumber);
lblDateNow.Text = "TRANSACTION DATE: " + DateTime.UtcNow.ToString("dddd, MMMM dd, yyyy");
//
lblCustomer.Text = SOI.CustomerName;
lblDatePeriodFrom.Text = "PERIOD FROM: " + SOI.PeriodFrom.ToString("MMMM dd, yyyy");
lblDatePerioTo.Text = "TO: " + SOI.PeriodTo.ToString("MMMM dd, yyyy");
//BI
if (SOI.BeginningInventoryVolume != 0)
{
lblBIVolume.Text = SOI.BeginningInventoryVolume.ToString("###,###");
}
else
{
lblBIVolume.Text = "(0)";
}
lblBIValue.Text = SOI.BeginningInventoryValue.ToString("###,###.00");
lblBITotalCost.Text = SOI.BeginningInventoryTotalCost.ToString("###,###.00");
lblBIAverageCost.Text = SOI.BeginningInventoryAverageCost.ToString("###,###.00");
//Delivery
lblDeliveryAvgCost.Text = SOI.DeliveryAverageCost.ToString("###,###.00");
lblDeliveryTotalCost.Text = SOI.DeliveryTotalCost.ToString("###,###.00");
lblDeliveryValue.Text = SOI.DeliveryValue.ToString("###,###.00");
if (SOI.DeliveryVolume != 0)
{
lblDeliveryVolume.Text = SOI.DeliveryVolume.ToString("###,###");
}
else
{
lblDeliveryVolume.Text = "(0)";
}
//PullOut
lblPullOutAvgCost.Text = SOI.ReturnsAverageCost.ToString("(###,###.00)");
lblPullOutTotalCost.Text = SOI.ReturnsTotalCost.ToString("(###,###.00)");
lblPullOutValue.Text = SOI.ReturnsValue.ToString("(###,###.00)");
if (SOI.ReturnsVolume != 0)
{
lblPullOutVolume.Text = SOI.ReturnsVolume.ToString("(###,###)");
}
else
{
lblPullOutVolume.Text = "(0)";
}
//grossSdales
lblGrossSalesAvgCost.Text = SOI.GrossSalesAverageCost.ToString("(###,###.00)");
lblGrossSalesTotalCost.Text = SOI.GrossSalesTotalCost.ToString("(###,###.00)");
lblGrossSalesValue.Text = SOI.GrossSalesValue.ToString("(###,###.00)");
if (SOI.GrossSalesVolume != 0)
{
lblGrossSalesVolume.Text = SOI.GrossSalesVolume.ToString("(###,###)");
}
else
{
lblGrossSalesVolume.Text = "(0)";
}
//adjustment
lblDebitAvgCost.Text = SOI.AdjustmentDebitAverageCost.ToString("###,###.00");
lblDebitTotalCost.Text = SOI.AdjustmentDebitTotalCost.ToString("###,###.00");
lblDebitValue.Text = SOI.AdjustmentDebitValue.ToString("###,###.00");
if (SOI.AdjustmentDebitVolume != 0)
{
lblDebitVolume.Text = SOI.AdjustmentDebitVolume.ToString("###,###");
}
else
{
lblDebitVolume.Text = "0";
}
lblCreditAvgCost.Text = SOI.AdjustmentCreditAverageCost.ToString("(###,###.00)");
lblCreditTotalCost.Text = SOI.AdjustmentCreditTotalCost.ToString("(###,###.00)");
lblCreditValue.Text = SOI.AdjustmentCreditValue.ToString("(###,###.00)");
if (SOI.AdjustmentCreditVolume != 0)
{
lblCreditVolume.Text = SOI.AdjustmentCreditVolume.ToString("(###,###)");
}
else
{
lblCreditVolume.Text = "(0)";
}
//Ending Inventory
lblEIAvgCost.Text = SOI.EndingInventoryAverageCost.ToString("###,###.00");
lblEITotalCost.Text = SOI.EndingInventoryTotalCost.ToString("###,###.00");
lblEIValue.Text = SOI.EndingInventoryValue.ToString("###,###.00");
if (SOI.EndingInventoryVolume != 0)
{
lblEIVolume.Text = SOI.EndingInventoryVolume.ToString("###,###");
}
else
{
lblEIVolume.Text = "(0)";
}
//PCount
lblAPCAvgCost.Text = SOI.ActualCountAverageCost.ToString("###,###.00");
lblAPCTotalCost.Text = SOI.ActualCostTotalCost.ToString("###,###.00");
lblAPCValue.Text = SOI.ActualCountValue.ToString("###,###.00");
if (SOI.ActualCountVolume != 0)
{
lblAPCVolume.Text = SOI.ActualCountVolume.ToString("###,###");
}
else
{
lblAPCVolume.Text = "(0)";
}
if (SOI.DiscrepancyVolume > 0)
{
lblDiscrepancyVolume.Text = SOI.DiscrepancyVolume.ToString("###,###");
}
else
{
lblDiscrepancyVolume.Text = (-1 * SOI.DiscrepancyVolume).ToString("(###,###)");
}
if (SOI.DiscrepancyValue > 0)
{
lblDiscrepancyValue.Text = SOI.DiscrepancyValue.ToString("###,###.00");
}
else
{
lblDiscrepancyValue.Text = (-1 * SOI.DiscrepancyValue).ToString("(###,###.00)");
}
if (SOI.DiscrepancyTotalCost > 0)
{
lblDiscrepancyTotalCost.Text = (SOI.DiscrepancyTotalCost).ToString("###,###.00");
}
else
{
lblDiscrepancyTotalCost.Text = (-1 * SOI.DiscrepancyTotalCost).ToString("(###,###.00)");
}
}
