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) { }
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
if (codex.Trim() != "")
{
if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Approve, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes)
{
T_CreditNoteHead objt_trnsferNote = new T_CreditNoteHead();
objt_trnsferNote.DocNo = txt_DocNo.Text.Trim();
objt_trnsferNote = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(objt_trnsferNote);
objt_trnsferNote.Approved = true;
objt_trnsferNote.ApprovedDate = DateTime.Now;
objt_trnsferNote.ApprovedUser = commonFunctions.Loginuser;
new T_CreditNoteHeadDL().Savet_CreditNoteHeadSP(objt_trnsferNote, 3);
//T_OrderTracking track = new T_OrderTracking();
//track.OFNo = objt_trnsferNote.OrderFormNo.Trim();
//track = new T_OrderTrackingDL().Selectt_OrderTracking(track, xEnums.OrderTrackingTypes.OrderNo);
//track.InvApproved = 1;
//track.InvApprovedDate = DateTime.Now;
//track.InvApprovedUser = commonFunctions.Loginuser;
//new T_OrderTrackingDL().Savet_OrderTrackingSP(track, 3);
getProcessedInvoices();
LoadDetails("");
UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_Update_Sucess, commonFunctions.Softwarename.Trim());
}
}
else
{
errorProvider1.SetError(dataGridView1, "Pelase select a order form from the list");
}
}
private void FindExisitingCN(string GrnNo)
{
if (GrnNo.Trim() != "")
{
if (T_CreditNoteHeadDL.ExistingT_CreditNoteHead(GrnNo.Trim()))
{
T_CreditNoteHead cat = new T_CreditNoteHead();
cat.DocNo = GrnNo.Trim();
cat = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(cat);
if (cat.Grouped == true)
{
lbl_processes.Text = "Grouped".ToUpper();
lbl_processes.Visible = true;
//errorProvider1.SetError(txt_DocNo, "Credit Note is already grouped.");
// commonFunctions.SetMDIStatusMessage("Credit Note is already grouped.", 1);
// return;
}
dtxCN.Clear();
dataGridView2.Refresh();
//clear error fields
errorProvider1.Clear();
//load and disable the data fields
txt_LocaCode.Text = cat.LocaCode.Trim();
txt_Customer.Text = cat.CustomerID.Trim();
txt_ManualID.Text = cat.ManualID.Trim();
dtxCN = GetCBBreakdowns(GrnNo);
dataGridView2.DataSource = dtxCN;
commonFunctions.FormatDataGrid(dataGridView2);
dataGridView2.Columns[0].Visible = false;
dataGridView2.Columns[1].Width = 90;
dataGridView2.Columns[2].Width = 100;
dataGridView2.Columns[4].Width = 90;
dataGridView2.Columns[5].Width = 50;
dataGridView2.Columns[6].Width = 200;
LoadPartSaved(GrnNo);
}
else
{
//if (formMode != 1)
//{
lbl_processes.Text = "Invalied".ToUpper();
lbl_processes.Visible = true;
errorProvider1.SetError(txt_DocNo, "Invalied Credit Note Number.");
commonFunctions.SetMDIStatusMessage("Invalied Credit Note Number.", 1);
//}
}
}
else
{
lbl_processes.Text = "".ToUpper();
lbl_processes.Visible = true;
commonFunctions.SetMDIStatusMessage("Please Enter Credit Note Number.", 2);
}
}
/// <summary>
/// Saves a record to the T_CreditNoteHead table.
/// </summary>
public Boolean Savet_CreditNoteHeadSP(T_CreditNoteHead t_CreditNoteHead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CreditNoteHeadSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.DocNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.LocaCode;
scom.Parameters.Add("@OFNo", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.OFNo;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.InvNo;
scom.Parameters.Add("@Dono", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.Dono;
scom.Parameters.Add("@CustomerID", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.CustomerID;
scom.Parameters.Add("@TypeX", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.TypeX;
scom.Parameters.Add("@AuditUser", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.AuditUser;
scom.Parameters.Add("@Statusx", SqlDbType.VarChar, 10).Value = t_CreditNoteHead.Statusx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_CreditNoteHead.Datex;
scom.Parameters.Add("@ManualID", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.ManualID;
scom.Parameters.Add("@DeliveredDate", SqlDbType.DateTime, 8).Value = t_CreditNoteHead.DeliveredDate;
scom.Parameters.Add("@PackingList", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.PackingList;
scom.Parameters.Add("@DeliveryStatus", SqlDbType.VarChar, 10).Value = t_CreditNoteHead.DeliveryStatus;
scom.Parameters.Add("@AgentStatus", SqlDbType.VarChar, 10).Value = t_CreditNoteHead.AgentStatus;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = t_CreditNoteHead.Remarks;
scom.Parameters.Add("@Processed", SqlDbType.Bit, 1).Value = t_CreditNoteHead.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_CreditNoteHead.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.ProcessedUser;
scom.Parameters.Add("@Grouped", SqlDbType.Bit, 1).Value = t_CreditNoteHead.Grouped;
scom.Parameters.Add("@GroupedDate", SqlDbType.DateTime, 8).Value = t_CreditNoteHead.GroupedDate;
scom.Parameters.Add("@GroupedUser", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.GroupedUser;
scom.Parameters.Add("@Approved", SqlDbType.Bit, 1).Value = t_CreditNoteHead.Approved;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_CreditNoteHead.ApprovedDate;
scom.Parameters.Add("@ApprovedUser", SqlDbType.VarChar, 20).Value = t_CreditNoteHead.ApprovedUser;
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_CreditNoteHead> SelectT_CreditNoteHeadMulti(T_CreditNoteHead objt_CreditNoteHead2)
{
List <T_CreditNoteHead> retval = new List <T_CreditNoteHead>();
try
{
strquery = @"select * from t_CreditNoteHead where DocNo = '" + objt_CreditNoteHead2.DocNo + "'";
DataTable dtt_CreditNoteHead = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_CreditNoteHead.Rows)
{
if (drType != null)
{
T_CreditNoteHead objt_CreditNoteHead = new T_CreditNoteHead();
objt_CreditNoteHead.DocNo = drType["DocNo"].ToString();
objt_CreditNoteHead.CompCode = drType["CompCode"].ToString();
objt_CreditNoteHead.LocaCode = drType["LocaCode"].ToString();
objt_CreditNoteHead.OFNo = drType["OFNo"].ToString();
objt_CreditNoteHead.InvNo = drType["InvNo"].ToString();
objt_CreditNoteHead.Dono = drType["Dono"].ToString();
objt_CreditNoteHead.CustomerID = drType["CustomerID"].ToString();
objt_CreditNoteHead.TypeX = drType["TypeX"].ToString();
objt_CreditNoteHead.AuditUser = drType["AuditUser"].ToString();
objt_CreditNoteHead.Statusx = drType["Statusx"].ToString();
objt_CreditNoteHead.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_CreditNoteHead.ManualID = drType["ManualID"].ToString();
objt_CreditNoteHead.DeliveredDate = DateTime.Parse(drType["DeliveredDate"].ToString());
objt_CreditNoteHead.PackingList = drType["PackingList"].ToString();
objt_CreditNoteHead.DeliveryStatus = drType["DeliveryStatus"].ToString();
objt_CreditNoteHead.AgentStatus = drType["AgentStatus"].ToString();
objt_CreditNoteHead.Remarks = drType["Remarks"].ToString();
objt_CreditNoteHead.Processed = bool.Parse(drType["Processed"].ToString());
objt_CreditNoteHead.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_CreditNoteHead.ProcessedUser = drType["ProcessedUser"].ToString();
objt_CreditNoteHead.Grouped = bool.Parse(drType["Grouped"].ToString());
objt_CreditNoteHead.GroupedDate = DateTime.Parse(drType["GroupedDate"].ToString());
objt_CreditNoteHead.GroupedUser = drType["GroupedUser"].ToString();
objt_CreditNoteHead.Approved = bool.Parse(drType["Approved"].ToString());
objt_CreditNoteHead.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_CreditNoteHead.ApprovedUser = drType["ApprovedUser"].ToString();
retval.Add(objt_CreditNoteHead);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
public T_CreditNoteHead Selectt_CreditNoteHeadApproval(string codex)
{
try
{
T_CreditNoteHead objt_CreditNoteHead = new T_CreditNoteHead();
strquery = @"select * from t_CreditNoteHead where DocNo = '" + codex.Trim() + "' and Processed =1";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_CreditNoteHead.DocNo = drType["DocNo"].ToString();
objt_CreditNoteHead.CompCode = drType["CompCode"].ToString();
objt_CreditNoteHead.LocaCode = drType["LocaCode"].ToString();
objt_CreditNoteHead.OFNo = drType["OFNo"].ToString();
objt_CreditNoteHead.InvNo = drType["InvNo"].ToString();
objt_CreditNoteHead.Dono = drType["Dono"].ToString();
objt_CreditNoteHead.CustomerID = drType["CustomerID"].ToString();
objt_CreditNoteHead.TypeX = drType["TypeX"].ToString();
objt_CreditNoteHead.AuditUser = drType["AuditUser"].ToString();
objt_CreditNoteHead.Statusx = drType["Statusx"].ToString();
objt_CreditNoteHead.Datex = DateTime.Parse(drType["Datex"].ToString());
objt_CreditNoteHead.ManualID = drType["ManualID"].ToString();
objt_CreditNoteHead.DeliveredDate = DateTime.Parse(drType["DeliveredDate"].ToString());
objt_CreditNoteHead.PackingList = drType["PackingList"].ToString();
objt_CreditNoteHead.DeliveryStatus = drType["DeliveryStatus"].ToString();
objt_CreditNoteHead.AgentStatus = drType["AgentStatus"].ToString();
objt_CreditNoteHead.Remarks = drType["Remarks"].ToString();
objt_CreditNoteHead.Processed = bool.Parse(drType["Processed"].ToString());
objt_CreditNoteHead.ProcessedDate = DateTime.Parse(drType["ProcessedDate"].ToString());
objt_CreditNoteHead.ProcessedUser = drType["ProcessedUser"].ToString();
objt_CreditNoteHead.Grouped = bool.Parse(drType["Grouped"].ToString());
objt_CreditNoteHead.GroupedDate = DateTime.Parse(drType["GroupedDate"].ToString());
objt_CreditNoteHead.GroupedUser = drType["GroupedUser"].ToString();
objt_CreditNoteHead.Approved = bool.Parse(drType["Approved"].ToString());
objt_CreditNoteHead.ApprovedDate = DateTime.Parse(drType["ApprovedDate"].ToString());
objt_CreditNoteHead.ApprovedUser = drType["ApprovedUser"].ToString();
return(objt_CreditNoteHead);
}
return(null);
}
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);
}
}
}
private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
codex = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
T_CreditNoteHead cat = new T_CreditNoteHead();
cat.DocNo = codex.Trim();
cat = new T_CreditNoteHeadDL().Selectt_CreditNoteHead(cat);
txt_DocNo.Text = cat.DocNo;
txt_Locacode.Text = cat.LocaCode.Trim();
txt_locationId_name.Text = findExisting.FindExisitingLoca(txt_Locacode.Text);
txt_Customer.Text = cat.CustomerID.Trim();
txt_Customer_name.Text = findExisting.FindExisitingCUstomer(txt_Customer.Text);
txt_Remarks.Text = cat.Remarks;
txt_manualno.Text = cat.ManualID;
txt_CNtypes.Text = cat.TypeX.Trim();
lbl_creditnotetype.Text = findExisting.FindExisitingCNType(txt_CNtypes.Text);
//dte_date.Value = cat.Datex.Value;
//dte_RecivedDate.Value = cat.RecivedDate.Value;
LoadDetails(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
}
}
