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 GenerateInvoiceReport(CSOMaster oSOMaster)
{
POS posdateset = new POS();
DataTable dtInv = posdateset.Invoice;
foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList)
{
DataRow drInv = dtInv.NewRow();
drInv["BranchName"] = currentBranch.CompBrn_Name;
drInv["Address"] = currentBranch.CompBrn_Street;
drInv["RoadNo"] = currentBranch.CompBrn_Road;
drInv["City"] = currentBranch.CompBrn_City;
drInv["Phone"] = currentBranch.CompBrn_Phone;
drInv["InvoiceNo"] = oSOMaster.SOMstr_Code;
drInv["VatClnNo"] = oSOMaster.SOMstr_VatClnNo;
drInv["ItemName"] = oSODetails.SODet_ItemName;
drInv["Qty"] = oSODetails.SODet_QTY;
drInv["Price"] = oSODetails.SODet_Price;
drInv["Amount"] = oSODetails.SODet_Amount;
drInv["Discount"] = oSODetails.SODet_Discount;
drInv["VATValue"] = oSODetails.SODet_VATValue;
dtInv.Rows.Add(drInv);
}
rptInvoice objrptInvoice = new rptInvoice();
objrptInvoice.SetDataSource(dtInv);
objrptInvoice.SetParameterValue(0, float.Parse(txtDiscountAmount.Text.Trim()));
objrptInvoice.SetParameterValue(1, currentUser.User_UserName.Trim());
objrptInvoice.SetParameterValue(2, txtCustomerPaid.Text.Trim());
objrptInvoice.SetParameterValue(3, txtChange.Text.Trim());
if (InvoiceRawKind == 0)
{
PrintDocument pd = new PrintDocument();
pd.DefaultPageSettings.PaperSize = new System.Drawing.Printing.PaperSize("POS", 4, 4);
InvoiceRawKind = (int)pd.PrinterSettings.DefaultPageSettings.PaperSize.RawKind;
}
objrptInvoice.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)InvoiceRawKind;
objrptInvoice.PrintToPrinter(1, true, 1, 1);
frmReportView ofrmReportView = new frmReportView();
CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
orptviewer.ReportSource = objrptInvoice;
orptviewer.AutoSize = false;
orptviewer.Show();
ofrmReportView.Show();
}
private void lvMemoList_DoubleClick(object sender, EventArgs e)
{
if (lvMemoList.Items.Count > 0)
{
if (lvMemoList.SelectedItems.Count == 1)
{
oSomaster = lvMemoList.FocusedItem.Tag as CSOMaster;
this.Close();
}
}
}
private void btnMemoSearch_Click(object sender, EventArgs e)
{
frmMemoList ofrmMemoList = new frmMemoList();
ofrmMemoList.ShowDialog();
oSoMaster = ofrmMemoList.oSomaster;
if (oSoMaster != null)
{
txtMenoNo.Text = oSoMaster.SOMstr_Code;
txtMenoNo.Tag = oSoMaster;
}
}
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 CSOMaster GetToSOFormData()
{
CSOMaster oSOMaster = new CSOMaster();
oSOMaster.SOMstr_OID = string.Empty;
oSOMaster.SOMstr_Branch = currentBranch.CompBrn_Code;
oSOMaster.SOMstr_Code = string.Empty;
oSOMaster.SOMstr_Date = DateTime.Now.Date;
oSOMaster.SOMstr_By = string.Empty;
oSOMaster.SOMstr_CustomerID = string.Empty;
oSOMaster.SOMstr_TotalAmt = float.Parse(txtTotalAmount.Text.Trim());
oSOMaster.SOMstr_DiscAmt = float.Parse(txtDiscountAmount.Text.Trim());
oSOMaster.SOMstr_NetAmt = float.Parse(this.txtNetPay.Text.Trim());
oSOMaster.SOMstr_FinalDest = string.Empty;
oSOMaster.SOMstr_TransportType = string.Empty;
oSOMaster.SOMstr_TransportNo = string.Empty;
oSOMaster.SOMstr_VatClnNo = string.Empty;
oSOMaster.SOMstr_VatDate = DateTime.Now.Date;
oSOMaster.SOMstr_PricingDate = DateTime.Now.Date;
oSOMaster.Creator = currentUser.User_OID;
oSOMaster.CreationDate = DateTime.Now.Date;
oSOMaster.UpdateBy = currentUser.User_OID;
oSOMaster.UpdateDate = DateTime.Now.Date;
oSOMaster.IsActive = "Y";
oSOMaster.Remarks = string.Empty;
if (rdCard.Checked)
{
oSOMaster.PaymentType = "Card";
oSOMaster.CardType = ddlCardType.SelectedItem.ToString();
}
else
{
oSOMaster.PaymentType = "Cash";
oSOMaster.CardType = "";
}
if (ddlSalesExecutive.SelectedIndex != -1)
{
oSOMaster.SalesMan = ddlSalesExecutive.SelectedValue.ToString();
}
for (int i = 0; i < this.dgvSaleItemList.Rows.Count - 1; i++)
{
DataGridViewRow dgvr = this.dgvSaleItemList.Rows[i];
if (float.Parse(dgvr.Cells["chQty"].Value.ToString()) > 0)
{
CSODetails oSODetails = new CSODetails();
oSODetails.SODet_OID = string.Empty;
oSODetails.SODet_Branch = currentBranch.CompBrn_Code;
oSODetails.SODet_MStrOID = string.Empty;
oSODetails.SODet_ItemSLNum = dgvr.Cells["chSLNum"].Value.ToString();
oSODetails.SODet_ItemOID = dgvr.Cells["chItemOId"].Value.ToString();
oSODetails.SODet_ItemName = dgvr.Cells["chItemName"].Value.ToString();
oSODetails.SODet_QTY = float.Parse(dgvr.Cells["chQty"].Value.ToString());
oSODetails.SODet_UOM = dgvr.Cells["chUOMOID"].Value.ToString();
oSODetails.SODet_Price = float.Parse(dgvr.Cells["chRate"].Value.ToString());
oSODetails.SODet_PPrice = float.Parse(dgvr.Cells["cPPrice"].Value.ToString());
oSODetails.SODet_Currency = dgvr.Cells["chCurrencyOID"].Value.ToString();
oSODetails.SODet_Amount = float.Parse(dgvr.Cells["chValue"].Value.ToString());
oSODetails.SODet_Discount = float.Parse(dgvr.Cells["chDiscountAmount"].Value.ToString());
oSODetails.SODet_VATValue = float.Parse(dgvr.Cells["chVatValue"].Value.ToString());
oSODetails.SODet_SDValue = 0.00f;
oSODetails.SODet_SDAmount = 0.00f;
oSODetails.SODet_VATAmount = 0.00f;
oSODetails.SODet_NetAmount = 0.00f;
oSODetails.SODet_BranchOID = currentBranch.CompBrn_OId;
// Advance Start
if (!defaultUserMode)
{
oSODetails.SODet_MStrOID = "SOMstrXX" + currentBranch.CompBrn_Code.Trim() + (("XXXXXX").Substring(0, 6 - currentBranch.CompBrn_Code.Trim().Length)) + "00" + VatClnNo;
}
// Advance End
oSOMaster.SOMstr_DetailsList.Add(oSODetails);
}
}
// Advance Start
if (!defaultUserMode)
{
oSOMaster.SOMstr_OID = "SOMstrXX" + currentBranch.CompBrn_Code.Trim() + (("XXXXXX").Substring(0, 6 - currentBranch.CompBrn_Code.Trim().Length)) + "00" + VatClnNo;
string sTemp = currentBranch.CompBrn_Code.Trim() + (("XXXXXX").Substring(0, 6 - currentBranch.CompBrn_Code.Trim().Length));
sTemp += DateTime.Now.ToString("yyddMM");
sTemp += VatClnNo.Substring(4, 4);
oSOMaster.SOMstr_Code = sTemp;
oSOMaster.SOMstr_VatClnNo = VatClnNo;
VatClnNo = ("00000001").Substring(0, 8 - (long.Parse(VatClnNo) + 1).ToString().Length) + (long.Parse(VatClnNo) + 1).ToString();
}
// Advance End
return(oSOMaster);
}
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);
}
