/// <summary> /// Function to insert values to Godown Table /// </summary> /// <param name="godowninfo"></param> public void GodownAdd(GodownInfo godowninfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("GodownAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@godownName", SqlDbType.VarChar); sprmparam.Value = godowninfo.GodownName; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = godowninfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = godowninfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = godowninfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
public void GodownAdd(GodownInfo godowninfo) { try { SPGodown.GodownAdd(godowninfo); } catch (Exception ex) { MessageBox.Show("GBll1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to Godown Table with same name /// </summary> /// <param name="godowninfo"></param> /// <returns></returns> public decimal GodownAddWithoutSameName(GodownInfo godowninfo) { decimal decReturnValue = 0; try { decReturnValue = SPGodown.GodownAddWithoutSameName(godowninfo); } catch (Exception ex) { MessageBox.Show("GBll8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decReturnValue; }
/// <summary> /// Function to get particular values from Godown table based on the parameter with narration /// </summary> /// <param name="decGodownId"></param> /// <returns></returns> public GodownInfo GodownWithNarrationView(decimal decGodownId) { GodownInfo godowninfo = new GodownInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("GodownWithNarrationView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal); sprmparam.Value = decGodownId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { godowninfo.GodownId = Convert.ToDecimal(sdrreader[0].ToString()); godowninfo.GodownName = sdrreader[1].ToString(); godowninfo.Narration = sdrreader[2].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return godowninfo; }
/// <summary> /// Function to Update values in Godown Table /// </summary> /// <param name="godowninfo"></param> /// <returns></returns> public bool GodownEditParticularField(GodownInfo godowninfo) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("godownEditParticularField", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal); sprmparam.Value = godowninfo.GodownId; sprmparam = sccmd.Parameters.Add("@godownName", SqlDbType.VarChar); sprmparam.Value = godowninfo.GodownName; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = godowninfo.Narration; int inAffectedRows = sccmd.ExecuteNonQuery(); if (inAffectedRows > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }
/// <summary> /// Function to insert values to Godown Table with same name /// </summary> /// <param name="godowninfo"></param> /// <returns></returns> public decimal GodownAddWithoutSameName(GodownInfo godowninfo) { // bool isSave = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("GodownAddWithoutSameName", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@godownName", SqlDbType.VarChar); sprmparam.Value = godowninfo.GodownName; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = godowninfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = godowninfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = godowninfo.Extra2; decimal decWork = Convert.ToDecimal( sccmd.ExecuteScalar()); if (decWork > 0) { return decWork; } else { return 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return 0; } finally { sqlcon.Close(); } }
/// <summary> /// Function to get particular values from Godown table based on the parameter with narration /// </summary> /// <param name="decGodownId"></param> /// <returns></returns> public GodownInfo GodownWithNarrationView(decimal decGodownId) { GodownInfo godowninfo = new GodownInfo(); try { godowninfo = SPGodown.GodownWithNarrationView(decGodownId); } catch (Exception ex) { MessageBox.Show("GBll9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return godowninfo; }
/// <summary> /// Function to get the godownId by godownname /// </summary> /// <param name="strGodown"></param> /// <returns></returns> public GodownInfo GodownIdByGodownName(string strGodown) { GodownInfo godowninfo = new GodownInfo(); try { godowninfo = SPGodown.GodownIdByGodownName(strGodown); } catch (Exception ex) { MessageBox.Show("GBll13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return godowninfo; }
/// <summary> /// Function to Update values in Godown Table /// </summary> /// <param name="godowninfo"></param> /// <returns></returns> public bool GodownEditParticularField(GodownInfo godowninfo) { bool isEdit = false; try { isEdit = SPGodown.GodownEditParticularField(godowninfo); } catch (Exception ex) { MessageBox.Show("GBll11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isEdit; }