private void button3_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Del, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
if (drowSaved != null)
{
if (drowSaved.Cells[0] != null)
{
T_CNParts ss = new T_CNParts();
ss.CNno = drowSaved.Cells[0].Value.ToString();
ss.ItemCode = drowSaved.Cells[2].Value.ToString();
ss.PartCode = drowSaved.Cells[4].Value.ToString();
ss.TagNumber = drowSaved.Cells[1].Value.ToString();
ss = new T_CNPartDL().Selectt_CNPart(ss);
if (!ss.Processed.Value)
{
//MessageBox.Show(drowSaved.Cells[2].Value.ToString());
T_CNPartDL.Delete_CNPart(drowSaved.Cells[0].Value.ToString(), drowSaved.Cells[2].Value.ToString(), drowSaved.Cells[4].Value.ToString(), drowSaved.Cells[1].Value.ToString());
LoadPartSaved(txt_DocNo.Text.Trim());
}
else
{
commonFunctions.SetMDIStatusMessage("Item already processed. cannot delete now", 1);
}
}
}
}
}
private void btn_save_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Process, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
T_CreditNoteHead alloc = new T_CreditNoteHead();
alloc.Dono = txt_DocNo.Text.Trim();
alloc = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(alloc);
decimal cumilative = decimal.Zero;
foreach (DataGridViewRow drowx in dgsave.Rows)
{
T_CNParts part = new T_CNParts();
part.CNno = drowx.Cells[0].Value.ToString().Trim();
part.ItemCode = drowx.Cells[2].Value.ToString().Trim();
part.PartCode = drowx.Cells[4].Value.ToString().Trim();
part.TagNumber = drowx.Cells[1].Value.ToString().Trim();
part = new T_CNPartDL().Selectt_CNPart(part);
part.Processed = true;
new T_CNPartDL().Savet_CNPartSP(part, 3);
}
}
catch (Exception ex) { }
}
}
public T_CNParts Selectt_CNPart(T_CNParts objt_CNPart)
{
try
{
strquery = @"SELECT * FROM dbo.T_CNParts WHERE (CNno = '" + objt_CNPart.CNno.Trim() + "') AND (ItemCode = '" + objt_CNPart.ItemCode.Trim() + "') AND (PartCode = '" + objt_CNPart.PartCode.Trim() + "') and TagNumber = '" + objt_CNPart.TagNumber.Trim() + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_CNPart.CNno = drType["CNno"].ToString();
objt_CNPart.TagNumber = drType["TagNumber"].ToString();
objt_CNPart.ItemCode = drType["ItemCode"].ToString();
objt_CNPart.PartCode = drType["PartCode"].ToString();
objt_CNPart.QTY = decimal.Parse(drType["QTY"].ToString());
objt_CNPart.Saved = bool.Parse(drType["Saved"].ToString());
objt_CNPart.Processed = bool.Parse(drType["Processed"].ToString());
objt_CNPart.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_CNPart.ProcessedUser = drType["ProcessedUser"].ToString();
return(objt_CNPart);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Saves a record to the T_CNParts table.
/// </summary>
public Boolean Savet_CNPartSP(T_CNParts t_CNPart, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CNPartsSave";
scom.Parameters.Add("@CNno", SqlDbType.VarChar, 20).Value = t_CNPart.CNno;
scom.Parameters.Add("@TagNumber", SqlDbType.VarChar, 20).Value = t_CNPart.TagNumber;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_CNPart.ItemCode;
scom.Parameters.Add("@PartCode", SqlDbType.VarChar, 20).Value = t_CNPart.PartCode;
scom.Parameters.Add("@QTY", SqlDbType.Decimal, 9).Value = t_CNPart.QTY;
scom.Parameters.Add("@Saved", SqlDbType.Bit, 1).Value = t_CNPart.Saved;
scom.Parameters.Add("@Processed", SqlDbType.Bit, 1).Value = t_CNPart.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_CNPart.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_CNPart.ProcessedUser;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public List <T_CNParts> SelectT_CNPartMulti(T_CNParts objt_CNPart2)
{
List <T_CNParts> retval = new List <T_CNParts>();
try
{
strquery = @"select * from t_CNPart where CNno = '" + objt_CNPart2.CNno + "'";
DataTable dtt_CNPart = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_CNPart.Rows)
{
if (drType != null)
{
T_CNParts objt_CNPart = new T_CNParts();
objt_CNPart.CNno = drType["CNno"].ToString();
objt_CNPart.TagNumber = drType["TagNumber"].ToString();
objt_CNPart.ItemCode = drType["ItemCode"].ToString();
objt_CNPart.PartCode = drType["PartCode"].ToString();
objt_CNPart.QTY = decimal.Parse(drType["QTY"].ToString());
objt_CNPart.Saved = bool.Parse(drType["Saved"].ToString());
objt_CNPart.Processed = bool.Parse(drType["Processed"].ToString());
objt_CNPart.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_CNPart.ProcessedUser = drType["ProcessedUser"].ToString();
retval.Add(objt_CNPart);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Add, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
try
{
T_CreditNoteHead alloc = new T_CreditNoteHead();
alloc.Dono = txt_DocNo.Text.Trim();
alloc = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(alloc);
decimal cumilative = decimal.Zero;
foreach (DataGridViewRow drowx in dataGridView1.Rows)
{
if (commonFunctions.ToDecimal(drowx.Cells[2].Value.ToString().Trim()) != decimal.Zero)
{
if (!T_CNPartDL.ExistingT_CNPart(txt_DocNo.Text.Trim(), drow.Cells[1].Value.ToString().Trim(), drow.Cells[2].Value.ToString().Trim(), drowx.Cells[0].Value.ToString().Trim()))
{
T_CNParts part = new T_CNParts();
part.CNno = txt_DocNo.Text.Trim();
part.ItemCode = drow.Cells[2].Value.ToString().Trim();
part.PartCode = drowx.Cells[0].Value.ToString().Trim();
part.Processed = false;
part.ProcessedDate = DateTime.Now;
part.ProcessedUser = commonFunctions.Loginuser;
part.QTY = commonFunctions.ToDecimal(drowx.Cells[2].Value.ToString().Trim());
part.Saved = false;
part.TagNumber = drow.Cells[1].Value.ToString().Trim();
new T_CNPartDL().Savet_CNPartSP(part, 1);
}
}
}
LoadPartSaved(txt_DocNo.Text.Trim());
}
catch (System.Data.SqlClient.SqlException ex) {
commonFunctions.SetMDIStatusMessage("Data Already exists for selected record", 1);
}
catch (Exception ex)
{
commonFunctions.SetMDIStatusMessage("Error when adding", 1);
}
}
}
