private void btnRefreshStockCard_Click(object sender, EventArgs e)
{
if (dxStockCardValiation.Validate())
{
// Bind the stock card.
var dataRow = (DataRowView)lkStockArchivePeriod.GetSelectedDataRow();
StockCardReport report;
if (chkStockCardArchive.Checked && dataRow != null)
{
report = ReportingReportFactory.CreateStockCard(Convert.ToInt32(lkStockCardActivity.EditValue), ItemID,
Convert.ToInt32(lkStockCardUnit.EditValue),
Convert.ToInt32(lkStockCardWarehouse.EditValue),
Convert.ToInt32(lkStockCardManufacturer.EditValue),
Convert.ToDateTime(dataRow["StartDate"]),
Convert.ToDateTime(dataRow["EndDate"]));
}
else
{
report = ReportingReportFactory.CreateStockCard(Convert.ToInt32(lkStockCardActivity.EditValue), ItemID,
Convert.ToInt32(lkStockCardUnit.EditValue),
Convert.ToInt32(lkStockCardWarehouse.EditValue), Convert.ToInt32(lkStockCardManufacturer.EditValue));
}
stockCardReport = report;
printStockCard.PrintingSystem = report.PrintingSystem;
report.PrintingSystem.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.ZoomToPageWidth, null);
// Generate the report's print document.
report.CreateDocument();
}
}
public static StockCardReport CreateStockCard(int activityID, int itemID, int unitID, int warehouse, int manufactuererID, DateTime?startDate = null, DateTime?endDate = null)
{
BLL.Balance balance = new Balance();
BLL.Item item = new Item();
item.LoadByPrimaryKey(itemID);
ItemUnit iunit = new ItemUnit();
iunit.LoadByPrimaryKey(unitID);
BLL.Warehouse physicalStore = new Warehouse();
physicalStore.LoadByPrimaryKey(warehouse);
var dataView = new DataView();
if (startDate == null || endDate == null)
{
dataView = Balance.GetStockCardByWarehouse(activityID, itemID, unitID, EthiopianDate.EthiopianDate.Now.FiscalYear,
warehouse, manufactuererID);
}
else
{
dataView = Balance.GetStockCardByDate(activityID, itemID, unitID, warehouse, manufactuererID,
startDate.Value, endDate.Value);
}
StockCardReport report = new StockCardReport();
report.DataSource = dataView;
// Bind the headers here.
report.StockCode.Text = item.StockCode;
report.Description.Text = item.FullItemName;
report.Unit.Text = iunit.Text;
Activity store = new Activity();
store.LoadByPrimaryKey(activityID);
report.Account.Text = store.AccountName;
report.SubAccount.Text = store.SubAccountName;
report.Activity.Text = store.Name;
Manufacturer manufacturers = new Manufacturer();
manufacturers.LoadByPrimaryKey(manufactuererID);
report.Manufacturer.Text = manufacturers.Name;
// TODO: add the Item Source Here (the suggested interpretation is that item source is supplier)
report.PrintedBy.Text = string.Format("Generated By: {0} On {1}", CurrentContext.LoggedInUserName,
BLL.DateTimeHelper.ServerDateTime.ToString("dd-MM-yyyy hh:mm tt"));
report.Store.Text = physicalStore.Name;
report.AppVersion.Text = "HCMIS";
return(report);
}
public StockCardReport IsHasRecord(long CustNo, DateTime PeriodDate)
{
StockCardReport SCRpt = new StockCardReport();
try
{
SCRpt = GetBeginningOnStockCard(CustNo, PeriodDate);
}
catch (Exception)
{
SCRpt = new StockCardReport();
//SCRpt = null;
}
return(SCRpt);
}
private void Acc_StockCard()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString);
ReportDocument rpt;
string rptDocCachedKey = null;
rptDocCachedKey = "StockCardRpt";
if (Cache[rptDocCachedKey] != null)
{
rpt = (StockCardRpt)Cache[rptDocCachedKey];
}
else
{
rpt = new StockCardRpt();
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 rptstockcard_new where custno = '" + CustNo + "' and datefrom = '" + DateFrom + "' and dateto = '" + DateTo + "'";
cmd.ExecuteNonQuery();
StockCardReportManager SCRManager = new StockCardReportManager();
StockCardReport SCR = SCRManager.IsHasRecord(CustNo, PrevDate);
if (SCRManager.HasRecord(CustNo, PrevDate) == true)
{
cmd.CommandTimeout = 300;
cmd.CommandText = "GenRptStockCard_Beg_StockCard '" + DateFrom + "', '" + DateTo + "', '" + PrevDate + "', " + CustNo + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
StoreOutStandingInventory SOIBeginning = SCRManager.IsHasRecordOnSOI(CustNo, PrevDate);
if (SOIBeginning != null)
{
cmd.CommandTimeout = 300;
cmd.CommandText = "GenRptStockCard_Beg_SOI '" + DateFrom + "', '" + DateTo + "', '" + PrevDate + "', " + CustNo + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandTimeout = 300;
cmd.CommandText = "GenRptStockCard_Beg_Pcount '" + DateFrom + "', '" + DateTo + "', " + CustNo + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
}
//cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "genrptstockcard_new '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
DataTable ResultSet = new DataTable();
cmd.CommandText = "genrptstockcardsales '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "'," + Request.QueryString["custno"] + ", '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "select * from rptstockcard_new 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 = (long)row[14];
////Balamt = (decimal)row[15];
////Balcost = (decimal)row[16];
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 rptstockcard_new 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;
}
