/// <summary>
/// Function to get details based on parameter
/// </summary>
/// <param name="dcProductid"></param>
/// <returns></returns>
public UnitConvertionInfo UnitViewAllByProductId(decimal dcProductid)
{
UnitConvertionInfo UnitConvertionInfo = new UnitConvertionInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitViewAllByProductId", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = dcProductid;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
UnitConvertionInfo.UnitconvertionId = decimal.Parse(sdrreader["unitconversionId"].ToString());
UnitConvertionInfo.UnitId = decimal.Parse(sdrreader["unitId"].ToString());
UnitConvertionInfo.ConversionRate = decimal.Parse(sdrreader["conversionRate"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(UnitConvertionInfo);
}
/// <summary>
/// Function to get details based on parameter
/// </summary>
/// <param name="unitConvertionInfo"></param>
public void UnitConverstionEditWhenProductUpdating(UnitConvertionInfo unitConvertionInfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConverstionEditWhenProductUpdating", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = unitConvertionInfo.ProductId;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = unitConvertionInfo.UnitId;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get particular values from UnitConversion table based on the parameter
/// </summary>
/// <param name="unitconvertionId"></param>
/// <returns></returns>
public UnitConvertionInfo UnitConvertionView(decimal unitconvertionId)
{
UnitConvertionInfo unitconvertioninfo = new UnitConvertionInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConvertionView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@unitconvertionId", SqlDbType.Decimal);
sprmparam.Value = unitconvertionId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
unitconvertioninfo.UnitconvertionId = decimal.Parse(sdrreader[0].ToString());
unitconvertioninfo.ProductId = decimal.Parse(sdrreader[1].ToString());
unitconvertioninfo.UnitId = decimal.Parse(sdrreader[2].ToString());
unitconvertioninfo.ConversionRate = decimal.Parse(sdrreader[3].ToString());
unitconvertioninfo.ExtraDate = DateTime.Parse(sdrreader[4].ToString());
unitconvertioninfo.Extra1 = sdrreader[5].ToString();
unitconvertioninfo.Extra2 = sdrreader[6].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(unitconvertioninfo);
}
/// <summary>
/// Function to get all the values from UnitConversion table
/// </summary>
/// <param name="unitconvertioninfo"></param>
public void UnitConvertionEdit(UnitConvertionInfo unitconvertioninfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConvertionEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@unitconvertionId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.UnitconvertionId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.ProductId;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.UnitId;
sprmparam = sccmd.Parameters.Add("@conversionRate", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.ConversionRate;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = unitconvertioninfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = unitconvertioninfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = unitconvertioninfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get all the values from UnitConversion table
/// </summary>
/// <param name="unitconvertioninfo"></param>
public void UnitConvertionEdit(UnitConvertionInfo unitconvertioninfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConvertionEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@unitconvertionId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.UnitconvertionId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.ProductId;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.UnitId;
sprmparam = sccmd.Parameters.Add("@conversionRate", SqlDbType.Decimal);
sprmparam.Value = unitconvertioninfo.ConversionRate;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = unitconvertioninfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = unitconvertioninfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = unitconvertioninfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function for new row added for multiple unit
/// </summary>
public void NewRowAddedForMulUnit()
{
try
{
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConversion = new UnitConvertionInfo();
for (int inI = 0; inI < dtblFromMulUnitForUpdate.Rows.Count; inI++)
{
if (Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[inI]["unitconvertionId"]) == 0)
{
infoUnitConversion.ConversionRate = Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[inI]["CnvertionRate"]);
infoUnitConversion.UnitId = Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[inI]["dgvtxtUnitId"]);
infoUnitConversion.Quantities = Convert.ToString(dtblFromMulUnitForUpdate.Rows[inI]["quantities"]);
infoUnitConversion.Extra1 = dtblFromMulUnitForUpdate.Rows[inI]["extra1"].ToString();
infoUnitConversion.Extra2 = dtblFromMulUnitForUpdate.Rows[inI]["extra2"].ToString();
infoUnitConversion.ExtraDate = Convert.ToDateTime(dtblFromMulUnitForUpdate.Rows[inI]["extraDate"]);
infoUnitConversion.ProductId = decProductIdForEdit;
spUnitConvertion.UnitConvertionAdd(infoUnitConversion);
}
}
}
catch (Exception ex)
{
MessageBox.Show("PC:79" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to update multiple unit details to tbl_UnitConversion table
/// </summary>
public void UnitConvertionEditTableFill()
{
try
{
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConversion = new UnitConvertionInfo();
for (int i = 0; i < dtblFromMulUnitForUpdate.Rows.Count; i++)
{
if (Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[i]["unitconvertionId"]) != 0)
{
infoUnitConversion.ConversionRate = Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[i]["CnvertionRate"]);
infoUnitConversion.UnitId = Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[i]["dgvtxtUnitId"]);
infoUnitConversion.Extra1 = dtblFromMulUnitForUpdate.Rows[i]["extra1"].ToString();
infoUnitConversion.Extra2 = dtblFromMulUnitForUpdate.Rows[i]["extra2"].ToString();
infoUnitConversion.ExtraDate = Convert.ToDateTime(dtblFromMulUnitForUpdate.Rows[i]["extraDate"]);
infoUnitConversion.UnitconvertionId = Convert.ToDecimal(dtblFromMulUnitForUpdate.Rows[i]["unitconvertionId"]);
infoUnitConversion.ProductId = decProductIdForEdit;
spUnitConvertion.UnitConvertionEdit(infoUnitConversion);
}
}
}
catch (Exception ex)
{
MessageBox.Show("PC:28" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to add multiple unit details to tbl_UnitConversion table
/// </summary>
public void UnitConvertionTableFill()
{
try
{
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConversion = new UnitConvertionInfo();
decimal decProductId = decSaveProduct;
if (btnSave.Text == "Update")
{
decProductId = decProductIdForEdit;
}
else
{
decProductId = decSaveProduct;
}
for (int i = 0; i < dtblMulUnit.Rows.Count; i++)
{
decimal decConversionRate = Convert.ToDecimal(dtblMulUnit.Rows[i]["CnvertionRate"]);
if (decConversionRate != 0)
{
infoUnitConversion.ConversionRate = Convert.ToDecimal(dtblMulUnit.Rows[i]["CnvertionRate"]);
infoUnitConversion.UnitId = Convert.ToDecimal(dtblMulUnit.Rows[i]["dgvtxtUnitId"]);
infoUnitConversion.Quantities = Convert.ToString(dtblMulUnit.Rows[i]["quantities"]);
infoUnitConversion.Extra1 = dtblMulUnit.Rows[i]["extra1"].ToString();
infoUnitConversion.Extra2 = dtblMulUnit.Rows[i]["extra2"].ToString();
infoUnitConversion.ExtraDate = Convert.ToDateTime(dtblMulUnit.Rows[i]["extraDate"]);
infoUnitConversion.ProductId = decProductId;
spUnitConvertion.UnitConvertionAdd(infoUnitConversion);
}
}
}
catch (Exception ex)
{
MessageBox.Show("PC:27" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to edit Product table
/// </summary>
public void ProductEditFill()
{
try
{
ProductSP spProduct = new ProductSP();
ProductInfo infoProduct = new ProductInfo();
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConvertion = new UnitConvertionInfo();
BatchSP spBatch = new BatchSP();
infoProduct.ProductName = txtName.Text.Trim();
infoProduct.ProductCode = txtProductCode.Text.Trim();
if (txtPurchaseRate.Text.Trim() == string.Empty)
{
infoProduct.PurchaseRate = 0;
}
else
{
infoProduct.PurchaseRate = Convert.ToDecimal(txtPurchaseRate.Text.Trim());
}
if (txtSalesRate.Text.Trim() == string.Empty)
{
infoProduct.SalesRate = 0;
}
else
{
infoProduct.SalesRate = Convert.ToDecimal(txtSalesRate.Text.Trim());
}
if (txtMrp.Text.Trim() == string.Empty)
{
infoProduct.Mrp = 0;
}
else
{
infoProduct.Mrp = Convert.ToDecimal(txtMrp.Text);
}
infoProduct.MaximumStock = Convert.ToDecimal(txtMaximumStock.Text.Trim());
infoProduct.MinimumStock = Convert.ToDecimal(txtMinimumStock.Text.Trim());
infoProduct.ReorderLevel = Convert.ToDecimal(txtReorderLevel.Text.Trim());
infoProduct.Extra1 = string.Empty;
infoProduct.Extra2 = string.Empty;
infoProduct.ExtraDate = DateTime.Now;
infoProduct.TaxId = Convert.ToDecimal(cmbTax.SelectedValue);
infoProduct.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue);
infoProduct.GroupId = Convert.ToDecimal(cmbGroup.SelectedValue);
infoProduct.Narration = txtNarration.Text;
infoProduct.ProductId = decProductIdForEdit;
infoUnitConvertion.ProductId = decProductIdForEdit;
infoUnitConvertion.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue);
if (cmbTax.SelectedIndex == 0)
{
infoProduct.TaxapplicableOn = string.Empty;
}
else
{
infoProduct.TaxapplicableOn = Convert.ToString(cmbTaxApplicableOn.SelectedItem);
}
if (cmbBrand.SelectedIndex != -1)
{
infoProduct.BrandId = Convert.ToDecimal(cmbBrand.SelectedValue);
}
else
{
infoProduct.BrandId = 1;
}
if (cmbSize.SelectedIndex != -1)
{
infoProduct.SizeId = Convert.ToDecimal(cmbSize.SelectedValue);
}
else
{
infoProduct.SizeId = 1;
}
if (cmbModalNo.SelectedIndex != -1)
{
infoProduct.ModelNoId = Convert.ToDecimal(cmbModalNo.SelectedValue);
}
else
{
infoProduct.ModelNoId = 1;
}
if (cmbDefaultGodown.SelectedIndex != -1)
{
infoProduct.GodownId = Convert.ToDecimal(cmbDefaultGodown.SelectedValue);
}
else
{
infoProduct.GodownId = 1;
}
if (cmbDefaultRack.SelectedIndex != -1)
{
infoProduct.RackId = Convert.ToDecimal(cmbDefaultRack.SelectedValue);
}
else
{
infoProduct.RackId = 1;
}
if (cmbAllowBatch.SelectedIndex == 0)
{
infoProduct.IsallowBatch = false;
spBatch.PartNoUpdate(decProductIdForEdit, txtPartNo.Text.Trim());
}
else
{
infoProduct.IsallowBatch = true;
}
if (cmbBom.SelectedIndex == 0)
{
infoProduct.IsBom = false;
}
else
{
if (isSaveBomCheck || isBomFromRegister)
{
infoProduct.IsBom = true;
}
else
{
infoProduct.IsBom = false;
}
}
if (cmbMultipleUnit.SelectedIndex == 0)
{
infoProduct.Ismultipleunit = false;
}
else
{
if ((isMulUnitFromRgister || isSaveMulUnitCheck))
{
infoProduct.Ismultipleunit = true;
}
else
{
infoProduct.Ismultipleunit = false;
}
}
if (cbxActive.Checked)
{
infoProduct.IsActive = true;
}
else
{
infoProduct.IsActive = false;
}
if (cbxReminder.Checked)
{
infoProduct.IsshowRemember = true;
}
else
{
infoProduct.IsshowRemember = false;
}
if (cmbOpeningStock.SelectedIndex == 0)
{
infoProduct.Isopeningstock = false;
}
else
{
infoProduct.Isopeningstock = true;
}
if (PublicVariables.isMessageEdit)
{
if (Messages.UpdateMessage())
{
isUpdated = spProduct.ProductEdit(infoProduct);
spUnitConvertion.UnitConverstionEditWhenProductUpdating(infoUnitConvertion);
}
}
else
{
isUpdated = spProduct.ProductEdit(infoProduct);
spUnitConvertion.UnitConverstionEditWhenProductUpdating(infoUnitConvertion);
}
}
catch (Exception ex)
{
MessageBox.Show("PC:25" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save data to product table
/// </summary>
public void ProductTableFill()
{
try
{
ProductSP spProduct = new ProductSP();
ProductInfo infoProduct = new ProductInfo();
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConvertion = new UnitConvertionInfo();
infoProduct.ProductName = txtName.Text.Trim();
infoProduct.ProductCode = txtProductCode.Text.Trim();
if (txtPurchaseRate.Text != string.Empty)
{
infoProduct.PurchaseRate = Convert.ToDecimal(txtPurchaseRate.Text.Trim());
}
else
{
infoProduct.PurchaseRate = 0;
}
if (txtSalesRate.Text != string.Empty)
{
infoProduct.SalesRate = Convert.ToDecimal(txtSalesRate.Text.Trim());
}
else
{
infoProduct.SalesRate = 0;
}
if (txtMrp.Text != string.Empty)
{
infoProduct.Mrp = Convert.ToDecimal(txtMrp.Text.Trim());
}
else
{
infoProduct.Mrp = 0;
}
infoProduct.MaximumStock = Convert.ToDecimal(txtMaximumStock.Text.Trim());
infoProduct.MinimumStock = Convert.ToDecimal(txtMinimumStock.Text.Trim());
infoProduct.ReorderLevel = Convert.ToDecimal(txtReorderLevel.Text.Trim());
infoProduct.Extra1 = string.Empty;
infoProduct.Extra2 = string.Empty;
infoProduct.ExtraDate = DateTime.Now;
infoProduct.TaxId = Convert.ToDecimal(cmbTax.SelectedValue);
infoProduct.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue);
infoProduct.GroupId = Convert.ToDecimal(cmbGroup.SelectedValue);
infoProduct.Narration = txtNarration.Text;
infoUnitConvertion.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue);
infoUnitConvertion.ConversionRate = 1;
infoUnitConvertion.Quantities = string.Empty;
infoUnitConvertion.Extra1 = string.Empty;
infoUnitConvertion.Extra2 = string.Empty;
infoUnitConvertion.ExtraDate = DateTime.Now;
if (cmbTax.SelectedIndex == 0)
{
infoProduct.TaxapplicableOn = "Rate";
}
else
{
infoProduct.TaxapplicableOn = Convert.ToString(cmbTaxApplicableOn.SelectedItem);
}
if (cmbBrand.SelectedIndex != -1)
{
infoProduct.BrandId = Convert.ToDecimal(cmbBrand.SelectedValue);
}
else
{
infoProduct.BrandId = 1;
}
if (cmbSize.SelectedIndex != -1)
{
infoProduct.SizeId = Convert.ToDecimal(cmbSize.SelectedValue);
}
else
{
infoProduct.SizeId = 1;
}
if (cmbModalNo.SelectedIndex != -1)
{
infoProduct.ModelNoId = Convert.ToDecimal(cmbModalNo.SelectedValue);
}
else
{
infoProduct.ModelNoId = 1;
}
if (cmbDefaultGodown.SelectedIndex != -1)
{
infoProduct.GodownId = Convert.ToDecimal(cmbDefaultGodown.SelectedValue);
}
else
{
infoProduct.GodownId = 1;
}
if (cmbDefaultRack.SelectedIndex != -1)
{
infoProduct.RackId = Convert.ToDecimal(cmbDefaultRack.SelectedValue);
}
else
{
infoProduct.RackId = 1;
}
if (cmbAllowBatch.SelectedIndex == 0)
{
infoProduct.IsallowBatch = false;
}
else
{
infoProduct.IsallowBatch = true;
}
if (cmbBom.SelectedIndex == 0)
{
infoProduct.IsBom = false;
}
else
{
if (isSaveBomCheck)
{
infoProduct.IsBom = true;
}
else
{
infoProduct.IsBom = false;
}
}
if (cmbOpeningStock.SelectedIndex == 0)
{
infoProduct.Isopeningstock = false;
}
else
{
infoProduct.Isopeningstock = true;
infoProduct.PurchaseRate = Convert.ToDecimal(dgvProductCreation.Rows[0].Cells["dgvtxtrate"].Value);
}
if (cmbMultipleUnit.SelectedIndex == 0)
{
infoProduct.Ismultipleunit = false;
}
else
{
if (isSaveMulUnitCheck)
{
infoProduct.Ismultipleunit = true;
}
else
{
infoProduct.Ismultipleunit = false;
}
}
if (cbxActive.Checked)
{
infoProduct.IsActive = true;
}
else
{
infoProduct.IsActive = false;
}
if (cbxReminder.Checked)
{
infoProduct.IsshowRemember = true;
}
else
{
infoProduct.IsshowRemember = false;
}
decSaveProduct = spProduct.ProductAdd(infoProduct);
infoUnitConvertion.ProductId = decSaveProduct;
spUnitConvertion.UnitConvertionAdd(infoUnitConvertion);
}
catch (Exception ex)
{
MessageBox.Show("PC:24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get details based on parameter
/// </summary>
/// <param name="dcProductid"></param>
/// <returns></returns>
public UnitConvertionInfo UnitViewAllByProductId(decimal dcProductid)
{
UnitConvertionInfo UnitConvertionInfo = new UnitConvertionInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitViewAllByProductId", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = dcProductid;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
UnitConvertionInfo.UnitconvertionId = decimal.Parse(sdrreader["unitconversionId"].ToString());
UnitConvertionInfo.UnitId = decimal.Parse(sdrreader["unitId"].ToString());
UnitConvertionInfo.ConversionRate = decimal.Parse(sdrreader["conversionRate"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return UnitConvertionInfo;
}
/// <summary>
/// Function to get details based on parameter
/// </summary>
/// <param name="unitConvertionInfo"></param>
public void UnitConverstionEditWhenProductUpdating(UnitConvertionInfo unitConvertionInfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConverstionEditWhenProductUpdating", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = unitConvertionInfo.ProductId;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = unitConvertionInfo.UnitId;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to get particular values from UnitConversion table based on the parameter
/// </summary>
/// <param name="unitconvertionId"></param>
/// <returns></returns>
public UnitConvertionInfo UnitConvertionView(decimal unitconvertionId)
{
UnitConvertionInfo unitconvertioninfo = new UnitConvertionInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("UnitConvertionView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@unitconvertionId", SqlDbType.Decimal);
sprmparam.Value = unitconvertionId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
unitconvertioninfo.UnitconvertionId = decimal.Parse(sdrreader[0].ToString());
unitconvertioninfo.ProductId = decimal.Parse(sdrreader[1].ToString());
unitconvertioninfo.UnitId = decimal.Parse(sdrreader[2].ToString());
unitconvertioninfo.ConversionRate = decimal.Parse(sdrreader[3].ToString());
unitconvertioninfo.ExtraDate = DateTime.Parse(sdrreader[4].ToString());
unitconvertioninfo.Extra1 = sdrreader[5].ToString();
unitconvertioninfo.Extra2 = sdrreader[6].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return unitconvertioninfo;
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
int inRowCount = dgvMultipleProductCreation.RowCount;
BatchSP spBatch = new BatchSP();
BatchInfo infoBatch = new BatchInfo();
ProductSP spProduct = new ProductSP();
ProductInfo infoProduct = new ProductInfo();
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
UnitConvertionInfo infoUnitConvertion = new UnitConvertionInfo();
for (int i = 0; i < inRowCount - 1; i++)
{
infoProduct.GroupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
infoProduct.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue.ToString());
infoProduct.TaxId = Convert.ToDecimal(cmbTax.SelectedValue.ToString());
if (cmbGoDown.SelectedIndex != -1)
{
infoProduct.GodownId = Convert.ToDecimal(cmbGoDown.SelectedValue.ToString());
}
else
{
infoProduct.GodownId = 0;
}
if (cmbRack.SelectedIndex != -1)
{
infoProduct.RackId = Convert.ToDecimal(cmbRack.SelectedValue.ToString());
}
else
{
infoProduct.RackId = 0;
}
infoProduct.MinimumStock = 0;
infoProduct.MaximumStock = 0;
infoProduct.ReorderLevel = 0;
infoProduct.IsallowBatch = false;
infoProduct.Ismultipleunit = false;
infoProduct.IsBom = false;
infoProduct.Isopeningstock = false;
infoProduct.IsActive = true;
infoProduct.IsshowRemember = false;
infoProduct.Narration = string.Empty;
infoProduct.Extra1 = string.Empty;
infoProduct.Extra2 = string.Empty;
infoProduct.PartNo = string.Empty;
infoProduct.TaxapplicableOn = cmbTaxApplication.SelectedItem.ToString();
infoProduct.ProductCode = dgvMultipleProductCreation.Rows[i].Cells["dgvtxtProductCode"].Value.ToString().Trim();
infoProduct.ProductName = dgvMultipleProductCreation.Rows[i].Cells["dgvtxtProductName"].Value.ToString().Trim();
if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbBrand"].Value != null)
{
infoProduct.BrandId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbBrand"].Value.ToString());
}
else
{
infoProduct.BrandId = 1;
}
if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbModel"].Value != null)
{
infoProduct.ModelNoId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbModel"].Value.ToString());
}
else
{
infoProduct.ModelNoId = 1;
}
if (dgvMultipleProductCreation.Rows[i].Cells["dgvcmbSize"].Value != null)
{
infoProduct.SizeId = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvcmbSize"].Value.ToString());
}
else
{
infoProduct.SizeId = 1;
}
infoProduct.PurchaseRate = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtPurchaseRate"].Value.ToString());
infoProduct.SalesRate = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtSalesRate"].Value.ToString());
infoProduct.Mrp = Convert.ToDecimal(dgvMultipleProductCreation.Rows[i].Cells["dgvtxtMRP"].Value.ToString());
decIdentity = spProduct.ProductAdd(infoProduct);
//...................................................................ADD UNIT TO UNIT CONVERSION TABLE...................................................................................//
infoUnitConvertion.ProductId = decIdentity;
infoUnitConvertion.UnitId = Convert.ToDecimal(cmbUnit.SelectedValue.ToString());
infoUnitConvertion.ConversionRate = 1;
infoUnitConvertion.ExtraDate = DateTime.Now;
infoUnitConvertion.Quantities = string.Empty;
infoUnitConvertion.Extra1 = string.Empty;
infoUnitConvertion.Extra2 = string.Empty;
spUnitConvertion.UnitConvertionAdd(infoUnitConvertion);
//...................................................................ADD BATCH TO BATCH TABLE...................................................................................//
Int32 inBarcode = spBatch.AutomaticBarcodeGeneration();
infoBatch.BatchNo = "NA";
infoBatch.ExpiryDate = DateTime.Now;
infoBatch.ManufacturingDate = DateTime.Now;
infoBatch.partNo = string.Empty;
infoBatch.ProductId = decIdentity;
infoBatch.narration = string.Empty;
infoBatch.ExtraDate = DateTime.Now;
infoBatch.barcode = Convert.ToString(inBarcode);
infoBatch.Extra1 = string.Empty;
infoBatch.Extra2 = string.Empty;
spBatch.BatchAddWithBarCode(infoBatch);
}
Messages.SavedMessage();
Clear();
}
catch (Exception ex)
{
MessageBox.Show("MPC14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to add the products to grid
/// </summary>
public void AddToGrid()
{
try
{
SettingsSP spSettings = new SettingsSP();
if (txtProductCode.Text.Trim() == null && txtProductCode.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter product code");
txtProductCode.Focus();
}
else if (cmbItem.SelectedIndex == -1 && cmbItem.SelectedValue == null)
{
Messages.InformationMessage("Select a product");
cmbItem.Focus();
}
else if (Convert.ToDecimal(txtQuantity.Text.Trim()) <= 0 || txtQuantity.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter quantity");
txtQuantity.Focus();
}
else if (cmbUnit.SelectedValue == null)
{
Messages.InformationMessage("Select a unit");
cmbUnit.Focus();
}
else if (spSettings.SettingsStatusCheck("AllowZeroValueEntry") == "No" && decimal.Parse(txtRate.Text.Trim()) <= 0 || txtRate.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter rate");
txtRate.Focus();
}
else
{
int inCurrentRowIndex = new int();
bool isExecutef = false;
if (rowIdToEdit == 0)
{
dgvPointOfSales.Rows.Add();
inCurrentRowIndex = dgvPointOfSales.Rows.Count - 1;
isExecutef = true;
}
else
{
for (int i = 0; i < dgvPointOfSales.Rows.Count; ++i)
{
if (dgvPointOfSales.Rows[i].Cells["rowId"].Value.ToString() == rowIdToEdit.ToString())
{
isExecutef = true;
inCurrentRowIndex = i;
break;
}
}
}
if (!isExecutef)
{
dgvPointOfSales.Rows.Add();
inCurrentRowIndex = dgvPointOfSales.Rows.Count - 1;
}
ProductInfo infoProduct = new ProductInfo();
BatchInfo infoBatch = new BatchInfo();
RackInfo infoRack = new RackInfo();
UnitConvertionInfo InfoUnitConvertion = new UnitConvertionInfo();
infoProduct = new ProductSP().ProductView(decProductId);
decimal dcProductBatch = new BatchSP().BatchIdViewByProductId(decProductId);
InfoUnitConvertion = new UnitConvertionSP().UnitViewAllByProductId(decProductId);
infoBatch = new BatchSP().BatchView(dcProductBatch);
decimal dcGodownId = infoProduct.GodownId;
GodownInfo infoGodown = new GodownInfo();
infoGodown = new GodownSP().GodownView(dcGodownId);
decimal dcRackId = infoProduct.RackId;
infoRack = new RackSP().RackView(dcRackId);
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtProductCode"].Value = txtProductCode.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtProductName"].Value = cmbItem.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtQuantity"].Value = txtQuantity.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtUnit"].Value = cmbUnit.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtRate"].Value = txtRate.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtGrossValue"].Value = txtGrossValue.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtTaxPercentage"].Value = cmbTax.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtTaxAmount"].Value = txtTaxAmount.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtNetAmount"].Value = txtNetAmount.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtDiscount"].Value = txtDiscountAmount.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtTotalAmount"].Value = txtAmount.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxttaxid"].Value = Convert.ToDecimal(cmbTax.SelectedValue);
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtProductId"].Value = infoProduct.ProductId;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtBatchId"].Value = dcProductBatch;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtRackId"].Value = infoProduct.RackId;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtGodownId"].Value = infoProduct.GodownId;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtUnitId"].Value = Convert.ToDecimal(cmbUnit.SelectedValue);
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtunitconversionId"].Value = InfoUnitConvertion.UnitconvertionId;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtBarcode"].Value = txtBarcode.Text;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtBatchno"].Value = infoBatch.BatchNo;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtGodownName"].Value = infoGodown.GodownName;
dgvPointOfSales.Rows[inCurrentRowIndex].Cells["dgvtxtRackName"].Value = infoRack.RackName;
TotalAmountCalculation();
ClearGroupbox();
dgvPointOfSales.CurrentCell = dgvPointOfSales[0, dgvPointOfSales.Rows.Count - 1];
txtBarcode.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("POS:34" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}