/// <summary> /// Function to insert values to Size Table and return the Curresponding row's Id /// </summary> /// <param name="infoSize"></param> /// <returns></returns> public decimal SizeAdding(SizeInfo infoSize) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("SizeAdding", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@size", SqlDbType.VarChar).Value = infoSize.Size; sqlcmd.Parameters.Add("@narration", SqlDbType.VarChar).Value = infoSize.Narration; sqlcmd.Parameters.Add("@extra1", SqlDbType.VarChar).Value = infoSize.Extra1; sqlcmd.Parameters.Add("@extra2", SqlDbType.VarChar).Value = infoSize.Extra2; decimal deceffectedrow = Convert.ToDecimal(sqlcmd.ExecuteScalar()); if (deceffectedrow > 0) { return deceffectedrow; } else { return 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return 0; } finally { sqlcon.Close(); } }
/// <summary> /// Function to insert values to Size Table /// </summary> /// <param name="sizeinfo"></param> public void SizeAdd(SizeInfo sizeinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SizeAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@sizeId", SqlDbType.Decimal); sprmparam.Value = sizeinfo.SizeId; sprmparam = sccmd.Parameters.Add("@size", SqlDbType.VarChar); sprmparam.Value = sizeinfo.Size; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = sizeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = sizeinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = sizeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = sizeinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to Update values in Size Table and return the status /// </summary> /// <param name="infoSize"></param> /// <returns></returns> public bool SizeEditing(SizeInfo infoSize) { bool isEdit = false; try { isEdit= spSize.SizeEditing(infoSize); } catch (Exception ex) { MessageBox.Show("SZ4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return isEdit; }
/// <summary> /// Function to insert values to Size Table and return the Curresponding row's Id /// </summary> /// <param name="infoSize"></param> /// <returns></returns> public decimal SizeAdding(SizeInfo infoSize) { decimal decSizeId = 0; try { decSizeId = spSize.SizeAdding(infoSize); } catch (Exception ex) { MessageBox.Show("SZ3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decSizeId; }
/// <summary> /// Function to get values from Size Table based on the parameter /// </summary> /// <param name="decSizeId"></param> /// <returns></returns> public SizeInfo SizeViewing(decimal decSizeId) { SizeInfo infoSize = new SizeInfo(); SqlDataReader sqldr = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("SizeViewing", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@sizeId", SqlDbType.Decimal).Value = decSizeId; sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoSize.SizeId = decimal.Parse(sqldr["SizeId"].ToString()); infoSize.Size = sqldr["Size"].ToString(); infoSize.Narration = sqldr["Narration"].ToString(); infoSize.Extra1 = sqldr["Extra1"].ToString(); infoSize.Extra2 = sqldr["Extra2"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqldr.Close(); sqlcon.Close(); } return infoSize; }
/// <summary> /// Function to get particular values from Size Table based on the parameter /// </summary> /// <param name="sizeId"></param> /// <returns></returns> public SizeInfo SizeView(decimal sizeId) { SizeInfo sizeinfo = new SizeInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SizeView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@sizeId", SqlDbType.Decimal); sprmparam.Value = sizeId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { sizeinfo.SizeId = decimal.Parse(sdrreader[0].ToString()); sizeinfo.Size = sdrreader[1].ToString(); sizeinfo.Narration = sdrreader[2].ToString(); sizeinfo.ExtraDate = DateTime.Parse(sdrreader[3].ToString()); sizeinfo.Extra1 = sdrreader[4].ToString(); sizeinfo.Extra2 = sdrreader[5].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return sizeinfo; }
/// <summary> /// Function to Update values in Size Table and return the status /// </summary> /// <param name="infoSize"></param> /// <returns></returns> public bool SizeEditing(SizeInfo infoSize) { bool isEdit = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("SizeEditing", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@sizeId", SqlDbType.Decimal).Value = infoSize.SizeId; sqlcmd.Parameters.Add("@size", SqlDbType.VarChar).Value = infoSize.Size; sqlcmd.Parameters.Add("@narration", SqlDbType.VarChar).Value = infoSize.Narration; int ineffectedrow = sqlcmd.ExecuteNonQuery(); if (ineffectedrow > 0) { isEdit = true; } else { isEdit = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return isEdit; }
/// <summary> /// Function to get values from Size Table based on the parameter /// </summary> /// <param name="decSizeId"></param> /// <returns></returns> public SizeInfo SizeViewing(decimal decSizeId) { SizeInfo infoSize = new SizeInfo(); try { infoSize = spSize.SizeViewing(decSizeId); } catch (Exception ex) { MessageBox.Show("SZ6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoSize; }