private void GetBasicParameters()
{
INVENTORY.DA.SystemInformation sysinfo = null;
ReportParameter rParam = new ReportParameter();
using (DEWSRMEntities db = new DEWSRMEntities())
{
sysinfo = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
if (sysinfo != null)
{
rParam = new ReportParameter("CompanyName", sysinfo.Name);
_ReportParameters.Add(rParam);
rParam = new ReportParameter("Address", sysinfo.Address);
_ReportParameters.Add(rParam);
rParam = new ReportParameter("Phone", sysinfo.TelephoneNo);
_ReportParameters.Add(rParam);
}
rParam = new ReportParameter("Logo", Application.StartupPath + @"\Logo.bmp");
_ReportParameters.Add(rParam);
}
}
private void fSystemInformation_Load(object sender, EventArgs e)
{
try
{
btnPhotoClearCus.Enabled = true;
btnEmpPPClear.Enabled = true;
//btnNIDClear.Enabled = true;
btnSuppClear.Enabled = true;
//btnSuppDocClear.Enabled = true;
using (DEWSRMEntities db = new DEWSRMEntities())
{
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
if (_SystemInformation != null)
{
RefreshValue();
}
else
{
_SystemInformation = new DA.SystemInformation();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ShowDlg(Product oProduct, bool IsNew)
{
_IsNew = IsNew;
_Product = oProduct;
using (DEWSRMEntities db = new DEWSRMEntities())
{
var _SysInfos = db.SystemInformations;
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
}
if (!_IsNew)
{
cboProType.Enabled = false;
}
PopulateUnitTypeCbo();
PopulateProTypeCbo();
PopulateTaxCbo();
RefreshWarrantyType();
RefreshValue();
this.ShowDialog();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
if (_SystemInformation.SystemInfoID <= 0)
{
RefreshObject();
_SystemInformation.SystemInfoID = db.SystemInformations.Count() > 0 ? db.SystemInformations.Max(obj => obj.SystemInfoID) + 1 : 1;
db.SystemInformations.Add(_SystemInformation);
}
else
{
_SystemInformation = db.SystemInformations.FirstOrDefault(obj => obj.SystemInfoID == _SystemInformation.SystemInfoID);
RefreshObject();
}
db.SaveChanges();
MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
//if (MessageBox.Show("Do you want to create another Customer?", "Create Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// if (ItemChanged != null)
// {
// ItemChanged();
// }
// this.Close();
//}
//else
//{
// if (ItemChanged != null)
// {
// ItemChanged();
// }
// _SystemInformation = new INVENTORY.DA.SystemInformation();
// RefreshValue();
//}
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public void ShowDlg(Employee oEmployee, bool IsNew)
{
_IsNew = IsNew;
DEWSRMEntities db = new DEWSRMEntities();
var _SysInfos = db.SystemInformations;
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
_Employee = oEmployee;
PopulateDesignationCbo();
RefreshValue();
this.ShowDialog();
}
public void ShowDlg(Branch oBranch, bool IsNew)
{
_IsNew = IsNew;
_Branch = oBranch;
using (DEWSRMEntities db = new DEWSRMEntities())
{
var _SysInfos = db.SystemInformations;
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
}
//PopulateCategoryCbo();
RefreshValue();
this.ShowDialog();
}
public void ShowDlg(Supplier oSupplier, bool IsNew)
{
_IsNew = IsNew;
db = new DEWSRMEntities();
var _SysInfos = db.SystemInformations;
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
_Supplier = oSupplier;
RefreshValue();
if (!_IsNew)
{
numOpeningDue.Enabled = false;
numPrvDue.Enabled = false;
}
this.ShowDialog();
}
public void ShowDlg(Customer oCustomer, bool IsNew)
{
_IsNew = IsNew;
_Customer = oCustomer;
using (DEWSRMEntities db = new DEWSRMEntities())
{
var _SysInfos = db.SystemInformations;
_SystemInformation = (from c in db.SystemInformations
where c.SystemInfoID == 1
select c).FirstOrDefault();
}
PopulateCusTypeCbo();
RefreshValue();
if (!_IsNew)
{
numOpeningDue.Enabled = false;
numPrevDue.Enabled = false;
}
this.ShowDialog();
}
void pdoc_PrintPage(object sender, PrintPageEventArgs e)
{
DEWSRMEntities db = new DEWSRMEntities();
SystemInformation oSys = db.SystemInformations.FirstOrDefault();
Graphics graphics = e.Graphics;
Font font = new Font("Courier New", 8);
float fontHeight = font.GetHeight();
int startX = 7;
int startY = 20;
int Offset = 30;
graphics.DrawString(" " + oSys.Name, new Font("Courier New", 9, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString(oSys.Address, new Font("Courier New", 8, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString(" " + oSys.TelephoneNo, new Font("Courier New", 8, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
String underLine1 = "-------------------------------------------------";
graphics.DrawString(underLine1, new Font("Courier New", 7), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString("Cashier Name:" + _CashierName, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString("Invoice No:" + _InvoiceNo, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 20;
graphics.DrawString("Date & Time:" + _InvoiceDate, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
String underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15; //-------
graphics.DrawString("Product " + " " + "" + " " + " Qty" + " " + "S.Rate" + " " + "Total", new Font("Courier New", 8, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
foreach (SOrderDetail oItem in _SOrder.SOrderDetails)
{
Offset = Offset + 15;
graphics.DrawString(oItem.Product.ProductName + "", new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15; //---------------------
graphics.DrawString(" " + "" + " " + Math.Round((decimal)oItem.Quantity, 0) + " " + Math.Round((decimal)oItem.UnitPrice, 2) + " " + Math.Round((decimal)oItem.UTAmount, 2), new Font("Courier New", 8, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
}
Offset = Offset + 15;
underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
graphics.DrawString("Total Dis. " + Math.Round(_TotalDis, 2), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
graphics.DrawString("Net Amount. " + Math.Round(_TotalAmt, 2), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
// Offset = Offset + 15;
//// graphics.DrawString("Prv. Due" + " " + Math.Round(_PrvDue,2), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(Color.Black), startX, startY + Offset);
// Offset = Offset + 15;
// graphics.DrawString("Grand Total :" + " " + Math.Round(_GrandTotal,2), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(Color.Black), startX, startY + Offset);
Offset = Offset + 15;
underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
graphics.DrawString("AdjustAmt. : " + Math.Round(_Adjust, 2), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
graphics.DrawString("Payable Amt : " + Math.Ceiling(_Payable), new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
Offset = Offset + 15;
underLine = "-------------------------------------------------";
graphics.DrawString(underLine, new Font("Courier New", 7, FontStyle.Bold), new SolidBrush(System.Drawing.Color.Black), startX, startY + Offset);
}
