private void btnReturn_Click(object sender, EventArgs e)
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
float DisAmt = float.Parse(txtDiscountAmount.Text.Trim());
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
oResult = oSOBO.Return(oSOMaster, DisAmt);
if (oResult.IsSuccess)
{
//MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
string SOMstID = (string)oResult.Data;
txtbarcode.Select();
this.LoadItemList();
MessageBox.Show("save success");
this.dgvSaleItemList.Rows.Clear();
this.txtItemName.Clear();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void LoaddMemoList()
{
lvMemoList.Items.Clear();
CResult oResult = new CResult();
CSOBO oSoBo = new CSOBO();
oResult = oSoBo.ReadSOFromToDate(dtpFromDate.Value.Date, dtpToDate.Value.Date, currentBranch.CompBrn_Code);
if (oResult.IsSuccess = true)
{
List <CSOMaster> oSoMasterList = oResult.Data as List <CSOMaster>;
if (oSoMasterList != null)
{
int i = 0;
foreach (CSOMaster oSoMaste in oSoMasterList)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = (i + 1).ToString("00");
lvi.SubItems.Add(oSoMaste.SOMstr_Code);
lvi.SubItems.Add(oSoMaste.SOMstr_Date.ToString());
lvi.SubItems.Add(oSoMaste.SOMstr_DtailList.SODet_QTY.ToString());
lvi.SubItems.Add(oSoMaste.SOMstr_NetAmt.ToString());
lvi.Tag = oSoMaste;
lvMemoList.Items.Add(lvi);
i++;
}
}
else if (oSoMasterList == null)
{
MessageBox.Show("You have no memo to reprint in the given date", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private List <CSOMaster> LoadItemWiseSales()
{
List <CSOMaster> oListSOMaster = new List <CSOMaster>();
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
DateTime date = dtpDate.Value.Date;
oResult = oCSOBO.ReadSalesItemWise(dtpDateFrom2.Value.Date, dtpDateTo2.Value.Date, ddlRptBranch3.SelectedValue.ToString().Trim(), cmbItemName.SelectedValue.ToString(), ddlExportedBranch.SelectedValue.ToString().Trim());
if (oResult.IsSuccess)
{
oListSOMaster = (List <CSOMaster>)oResult.Data;
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
oListSOMaster = null;
}
// Advance Start
if (!defaultUserMode)
{
string m_sAdvanceConfigFileName = "AdvanceConfigAndLogFile.config";
List <CSOMaster> oListSOMaster2 = new List <CSOMaster>();
System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
if (File.Exists(m_sAdvanceConfigFileName))
{
using (Stream stream = new FileStream(m_sAdvanceConfigFileName, FileMode.Open, FileAccess.Read, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateDecryptor(baKey, baIV), CryptoStreamMode.Read);
//
oListSOMaster2 = (List <CSOMaster>)formatter.Deserialize(cryptoStream);
//
cryptoStream.Close();
}
}
if (oListSOMaster2.Count > 0)
{
foreach (CSOMaster oSOMaster in oListSOMaster2)
{
if (oSOMaster.SOMstr_Date.ToShortDateString() == dtpDate.Value.Date.ToShortDateString())
{
oListSOMaster.Add(oSOMaster);
}
}
}
}
// Advance End
return(oListSOMaster);
}
private void ShowReport()
{
List <CReturnItem> oListCReturnItem = new List <CReturnItem>();
//List<CSOMaster> oListSOMasterretu = new List<CSOMaster>();
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
DateTime date = dtpDate.Value.Date;
oListCReturnItem = oCSOBO.ReadSalesReturn(dtpDate.Value.Date, ddlRptBranch.SelectedItem.ToString());// currentBranch.CompBrn_Code);
//oListCReturnItem.Add(oListSOMasterretu);
New oPosDataSet11 = new New();
DataTable dtReturn = oPosDataSet11.ReturnItems;
//foreach (CSOMaster oSoMaster in oListSOMasterretu)
//{
//oListCReturnItem.Add(oSoMaster);
//}
foreach (CReturnItem oSoDetail in oListCReturnItem)
{
DataRow odr = dtReturn.NewRow();
odr["ItemName"] = oSoDetail.ItemName;
odr["Ret_QTY"] = oSoDetail.Ret_QTY;
odr["ItemPrice"] = float.Parse(oSoDetail.ItemPrice.ToString());
odr["BranchName"] = oSoDetail.Ret_BranchOID;
odr["Ret_DiscountAmount"] = oSoDetail.Ret_DiscountAmount;
odr["ReturnDate"] = oSoDetail.date;
dtReturn.Rows.Add(odr);
}
ETLPOS.Reports.ReturnReport orpt = new ETLPOS.Reports.ReturnReport();
orpt.SetDataSource(oPosDataSet11);
//orpt.SetParameterValue(0, currentBranch.CompBrn_OId.Trim());
orpt.SetParameterValue(0, dtpDate.Value.Date);
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
orptviewer.ReportSource = orpt;
// orptviewer.AutoSize = false;
orptviewer.Show();
ofrmReportView.Show();
//crystalReportViewer1.ReportSource = orpt;
//crystalReportViewer1.Show();
}
//Report Stock Details-----------
private void ReportStockDetails()
{
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
oResult = oCSOBO.ReportStockDatials(currentBranch.CompBrn_OId.Trim());
if (oResult.IsSuccess)
{
DataSet ds = (DataSet)oResult.Data;
POS posdateset = new POS();
DataTable dtStockDetail = posdateset.StockDetail;
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
DataRow drStockDetail = dtStockDetail.NewRow();
drStockDetail["ItemName"] = dr1["Item_ItemName"];
drStockDetail["Qty"] = dr1["QTY"];
drStockDetail["Pprice"] = dr1["Pprice"];
drStockDetail["Sprice"] = dr1["Price"];
drStockDetail["ItemGroupCode"] = dr1["Item_GroupID"];
drStockDetail["ItemGroupName"] = dr1["CatCode"];
drStockDetail["ItemCode"] = dr1["Item_Code"];
dtStockDetail.Rows.Add(drStockDetail);
}
rptStockDetails oStockrpt = new rptStockDetails();
oStockrpt.SetDataSource(dtStockDetail);
oStockrpt.SetParameterValue(0, currentBranch.CompBrn_Branch.Trim());
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
orptviewer.ReportSource = oStockrpt;
orptviewer.Show();
ofrmReportView.Show();
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PopulateReport()
{
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
oResult = oCSOBO.DailyCurrentStockReport(currentBranch.CompBrn_OId.Trim());
if (oResult.IsSuccess)
{
DataSet ds = (DataSet)oResult.Data;
POS posdateset = new POS();
DataTable dtDailySale = posdateset.Stock;
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
DataRow drDailySale = dtDailySale.NewRow();
drDailySale["Qty"] = dr1["Qty"];
drDailySale["ItemName"] = dr1["ItemName"];
drDailySale["Invtype"] = Enum.GetName(typeof(EInvType), dr1["Invt_InvType"]);
dtDailySale.Rows.Add(drDailySale);
}
rptCurrStock oStockrpt = new rptCurrStock();
oStockrpt.SetDataSource(dtDailySale);
oStockrpt.SetParameterValue(0, currentUser.User_UserName.Trim());
oStockrpt.SetParameterValue(1, currentBranch.CompBrn_Branch.Trim());
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
orptviewer.ReportSource = oStockrpt;
orptviewer.Show();
ofrmReportView.Show();
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void txtCustomerPaid_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(e.KeyChar >= 48 && e.KeyChar <= 57) && !(e.KeyChar == 8))
{
e.Handled = true;
}
if (e.KeyChar == 13)
{
DialogResult res = MessageBox.Show("Confirm Salse", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res.ToString() == "Yes")
{
if (defaultUserMode)
{
if (ValidateToBSaveData())
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
oResult = oSOBO.Create(oSOMaster);
if (oResult.IsSuccess)
{
//MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
string SOMstID = (string)oResult.Data;
this.GenerateInvoiceReport(SOMstID);
this.ClearAll();
this.LoadItemList();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (txtMenoNo.Text != "")
{
CSOBO oSoBo = new CSOBO();
List <CSOMaster> oSoMasterList = oSoBo.GetMemoData((txtMenoNo.Tag as CSOMaster).SOMstr_Code, (txtMenoNo.Tag as CSOMaster).SOMstr_Date, currentBranch.CompBrn_Branch);
POS oPosDataSet = new POS();
DataTable oDt = oPosDataSet.Tables["MemoReprint"];
foreach (CSOMaster oSoMaster in oSoMasterList)
{
DataRow odr = oDt.NewRow();
odr["BranchName"] = oSoMaster.SOMstr_Branch;
odr["MemoNo"] = oSoMaster.SOMstr_Code;
odr["MemoDate"] = oSoMaster.SOMstr_Date;
odr["Discount"] = int.Parse(oSoMaster.SOMstr_DiscAmt.ToString());
foreach (CSODetails oSoDetail in oSoMaster.SOMstr_DetailsList)
{
odr["ItemName"] = oSoDetail.SODet_ItemName;
odr["Qty"] = oSoDetail.SODet_QTY;
odr["Price"] = float.Parse(oSoDetail.SODet_Price.ToString());
odr["Amount"] = float.Parse(oSoDetail.SODet_SDAmount.ToString());
}
oDt.Rows.Add(odr);
}
txtMenoNo.Text = "";
rptMemoReprint orptMemoReprint = new rptMemoReprint();
orptMemoReprint.SetDataSource(oPosDataSet);
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer oCristalReportViewer = (CrystalReportViewer)ofrmReportView.Controls["rptViewer"];
oCristalReportViewer.ReportSource = orptMemoReprint;
oCristalReportViewer.Show();
ofrmReportView.Show();
}
}
private void btnSaveImportedData_Click(object sender, EventArgs e)
{
List <CSOMaster> oListSOMaster = new List <CSOMaster>();
openFileDialog1.InitialDirectory = @"H:\";
openFileDialog1.Filter = "Sales File (*.Salexp)|*.Salexp";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
IFormatter formatter = new BinaryFormatter();
if (File.Exists(openFileDialog1.FileName))
{
using (Stream stream = new FileStream(openFileDialog1.FileName, FileMode.Open, FileAccess.Read, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateDecryptor(baKey, baIV), CryptoStreamMode.Read);
//
oListSOMaster = (List <CSOMaster>)formatter.Deserialize(cryptoStream);
//
cryptoStream.Close();
}
}
}
if (oListSOMaster.Count > 0)
{
if (currentBranch.CompBrn_OId.Trim() == ((CSOMaster)oListSOMaster[0]).ExportedToBrnOID.Trim())
{
//Save data to t_somstr and t_sodet
if (oListSOMaster.Count > 0)
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
if (oListSOMaster.Count > 0)
{
foreach (CSOMaster oSOMaster in oListSOMaster)
{
oResult = oSOBO.Import(oSOMaster, currentBranch.CompBrn_Branch, currentBranch.CompBrn_OId);
if (!oResult.IsSuccess)
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
}
if (oResult.IsSuccess)
{
MessageBox.Show("Successfully Done ", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
// UPdate inventory
}
}
}
else
{
MessageBox.Show("You can not access the selected file.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
oListSOMaster = null;
}
}
}
private void ShowReport()
{
#region 1
List <CSOMaster> oListSOMaster = LoadSOData();
POS posdateset = new POS();
DataTable dtDailySale = posdateset.DailySales;
foreach (CSOMaster oSOMaster in oListSOMaster)
{
int i = 0;
foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList)
{
DataRow drDailySale = dtDailySale.NewRow();
//drDailySale["InvoiceNo"] = dr1["InvoiceNo"];
drDailySale["BranchName"] = oSOMaster.SOMstr_Branch;
drDailySale["Address"] = currentBranch.CompBrn_Street;
drDailySale["Road"] = currentBranch.CompBrn_Road;
drDailySale["City"] = currentBranch.CompBrn_City;
drDailySale["Phone"] = currentBranch.CompBrn_Phone;
drDailySale["Mobile"] = currentBranch.CompBrn_Mobile;
drDailySale["ItemName"] = oSODetails.SODet_ItemName;
drDailySale["Qty"] = oSODetails.SODet_QTY;
drDailySale["Rate"] = oSODetails.SODet_Price;
drDailySale["Amount"] = oSODetails.SODet_Amount;
drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt;
if (i == 0)
{
drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt;
}
if (i != 0)
{
drDailySale["DiscAmount"] = 0;
}
drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt;
drDailySale["PPrice"] = oSODetails.SODet_PPrice;
dtDailySale.Rows.Add(drDailySale);
i++;
}
}
#endregion
List <CReturnItem> oListCReturnItem = new List <CReturnItem>();
//List<CSOMaster> oListSOMasterretu = new List<CSOMaster>();
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
DateTime date = dtpDate.Value.Date;
oListCReturnItem = oCSOBO.ReadSalesReturn(dtpDate.Value.Date, currentBranch.CompBrn_Code);
//oListCReturnItem.Add(oListSOMasterretu);
New PosDataSet11 = new New();
DataTable dtReturn = PosDataSet11.ReturnItems;
//foreach (CSOMaster oSoMaster in oListSOMasterretu)
//{
//oListCReturnItem.Add(oSoMaster);
//}
foreach (CReturnItem oSoDetail in oListCReturnItem)
{
DataRow odr = dtReturn.NewRow();
odr["ItemName"] = oSoDetail.ItemName;
odr["Ret_QTY"] = oSoDetail.Ret_QTY;
odr["ItemPrice"] = float.Parse(oSoDetail.ItemPrice.ToString());
odr["BranchName"] = oSoDetail.Ret_BranchOID;
odr["Ret_DiscountAmount"] = oSoDetail.Ret_DiscountAmount;
//odr["ReturnDate"] = oSoDetail.date;
dtReturn.Rows.Add(odr);
}
//ReturnReport re = new ReturnReport();
//re.SetDataSource(PosDataSet11);
rptDailySales orpt = new rptDailySales();
orpt.SetDataSource(posdateset);
//orpt.Load("ReturnReport.rpt");
orpt.OpenSubreport("ReturnReport.rpt").SetDataSource(PosDataSet11);
orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim());
orpt.SetParameterValue(1, dtpDate.Value.Date);
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
orptviewer.ReportSource = orpt;
// orptviewer.AutoSize = false;
orptviewer.Show();
ofrmReportView.Show();
//crystalReportViewer1.ReportSource = orpt;
//crystalReportViewer1.Show();
}
private void GenerateInvoiceReport(string InvoiceID)
{
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
oResult = oCSOBO.ReadInvoiceReport(InvoiceID);
if (oResult.IsSuccess)
{
DataSet ds = (DataSet)oResult.Data;
POS posdateset = new POS();
DataTable dtInv = posdateset.Invoice;
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
DataRow drInv = dtInv.NewRow();
drInv["BranchName"] = dr1["BranchName"];
drInv["Address"] = dr1["Address"];
drInv["RoadNo"] = dr1["RoadNo"];
drInv["City"] = dr1["City"];
drInv["Phone"] = dr1["Phone"];
drInv["InvoiceNo"] = dr1["InvoiceNo"];
drInv["VatClnNo"] = dr1["VatClnNo"];
drInv["ItemName"] = dr1["ItemName"];
drInv["Qty"] = dr1["Qty"];
drInv["Price"] = dr1["Price"];
drInv["Amount"] = dr1["Amount"];
drInv["Discount"] = dr1["Discount"];
drInv["VATValue"] = dr1["VATValue"];
drInv["TIN"] = dr1["TIN"];
drInv["PaymentType"] = dr1["PaymentType"];
dtInv.Rows.Add(drInv);
}
if (txtDiscountAmount.Text.Trim() == "")
{
txtDiscountAmount.Text = "0";
}
rptInvoice2nd objrptInvoice = new rptInvoice2nd();
objrptInvoice.SetDataSource(dtInv);
objrptInvoice.SetParameterValue(0, float.Parse(txtDiscountAmount.Text.Trim()));
objrptInvoice.SetParameterValue(1, currentUser.User_UserName.Trim());
objrptInvoice.SetParameterValue(2, decimal.Parse(txtCustomerPaid.Text.Trim()));
objrptInvoice.SetParameterValue(3, decimal.Parse(txtChange.Text.Trim()));
objrptInvoice.PrintToPrinter(1, true, 1, 100);
//frmReportView ofrmReportView = new frmReportView();
//CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
//orptviewer.ReportSource = objrptInvoice;
//orptviewer.Size = new Size(4, 4);
//orptviewer.AutoSize = false;
//orptviewer.Show();
//ofrmReportView.Show();
// objrptInvoice.PrintToPrinter(1, true, 1, 100);
//frmReportView ofrmReportView = new frmReportView();
//CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
//orptviewer.ReportSource = objrptInvoice;
//orptviewer.Size = new Size(4, 4);
//orptviewer.AutoSize = false;
//orptviewer.Show();
//ofrmReportView.Show();
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSaveAndPrint_Click(object sender, EventArgs e)
{
if (defaultUserMode)
{
if (ValidateToBSaveData())
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
oResult = oSOBO.Create(oSOMaster);
if (oResult.IsSuccess)
{
//MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
string SOMstID = (string)oResult.Data;
this.GenerateInvoiceReport(SOMstID);
this.ClearAll();
txtbarcode.Select();
this.LoadItemList();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
else
{
// Advance Start
string m_sAdvanceConfigFileName = "AdvanceConfigAndLogFile.config";
if (ValidateToBSaveData())
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
List <CSOMaster> oListSOMaster = new List <CSOMaster>();
System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
if (File.Exists(m_sAdvanceConfigFileName))
{
using (Stream stream = new FileStream(m_sAdvanceConfigFileName, FileMode.Open, FileAccess.Read, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateDecryptor(baKey, baIV), CryptoStreamMode.Read);
//
oListSOMaster = (List <CSOMaster>)formatter.Deserialize(cryptoStream);
//
cryptoStream.Close();
}
}
oListSOMaster.Add(oSOMaster);
formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
using (Stream stream = new FileStream(m_sAdvanceConfigFileName, FileMode.OpenOrCreate, FileAccess.Write, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateEncryptor(baKey, baIV), CryptoStreamMode.Write);
//
formatter.Serialize(cryptoStream, oListSOMaster);
//
cryptoStream.Close();
}
{
CResult oResult2 = new CResult();
CGRBO oGRBO = new CGRBO();
oResult2 = oGRBO.ReduceByItemOID(oSOMaster.SOMstr_DetailsList);
}
//this.LoadItemList();
this.GenerateInvoiceReport(oSOMaster);
this.ClearAll();
txtbarcode.Select();
}
//
}
// Advance End
}
}
private static List <DataTable> SplitTable(DataTable table, int batchSize)
{
List <DataTable> dts = new List <DataTable>();
DataColumn[] itemcols = table.Columns.Cast <DataColumn>()
.Where(c => c.ColumnName.StartsWith("SOM"))
.Select(c => new DataColumn(c.ColumnName, c.DataType))
.ToArray();
DataColumn[] uoCols = table.Columns.Cast <DataColumn>()
.Where(c => c.ColumnName.StartsWith("SOD"))
.Select(c => new DataColumn(c.ColumnName, c.DataType))
.ToArray();
var t_SOMstr = new DataTable();
t_SOMstr.Columns.AddRange(itemcols);
var t_SODet = new DataTable();
t_SODet.Columns.AddRange(uoCols);
foreach (DataRow row in table.Rows)
{
DataRow aRow = t_SOMstr.Rows.Add();
DataRow bRow = t_SODet.Rows.Add();
foreach (DataColumn aCol in itemcols)
{
aRow.SetField(aCol, row[aCol.ColumnName]);
}
foreach (DataColumn bCol in uoCols)
{
bRow.SetField(bCol, row[bCol.ColumnName]);
}
}
// DataTable dt = new DataTable();
List <CSOMaster> items = t_SOMstr.DataTableToList <CSOMaster>();
string TobeDistinct = "SOMstr_OID";
// DataTable dtDistinct = GetDistinctRecords(t_SOMstr, TobeDistinct);
//Following function will return Distinct records for Name, City and State column.
var distinctList = from p in items
group p by new { p.SOMstr_Code } //or group by new {p.ID, p.Name, p.Whatever}
into mygroup
select mygroup.FirstOrDefault();
foreach (var item in items)
{
CSOMaster oitem = item;
CSOBO oitembo = new CSOBO();
CResult oresult = new CResult();
oitem.CreationDate = Convert.ToDateTime(t_SOMstr.Rows[0]["SOMstr_CreationDate"].ToString());
oitem.Creator = t_SOMstr.Rows[0]["SOMstr_Creator"].ToString();
oitem.UpdateBy = t_SOMstr.Rows[0]["SOMstr_UpdateBy"].ToString();
oitem.UpdateDate = Convert.ToDateTime(t_SOMstr.Rows[0]["SOMstr_UpdateDate"].ToString());
oitem.IsActive = t_SOMstr.Rows[0]["SOMstr_IsActive"].ToString();
oitem.Remarks = t_SOMstr.Rows[0]["SOMstr_Remarks"].ToString();
List <CSODetails> umos = t_SODet.DataTableToList <CSODetails>();
foreach (var sodetails in umos)
{
CSODetails ouom = sodetails;
oitem.SOMstr_DetailsList.Add(ouom);
//oresult = oitembo.CreateImport(ouom);
}
oresult = oitembo.CreateSalesImport(oitem);
}
// dts.Add(t_Item);
//dts.Add(t_UOM);
return(dts);
}
