public GRN_Payment GetByGRNNO(long GRNNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", GRNNO)
};
GRN_Payment obj = new GRN_Payment();
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRN_Payment_ByGRNNO", paramList);
if (dt.Rows.Count != 0)
{
obj.GRNNo = Convert.ToInt64(dt.Rows[0]["GRNNO"]);
obj.InvoiceNo = Convert.ToString(dt.Rows[0]["InvoiceNo"]);
obj.InvoiceType = Convert.ToString(dt.Rows[0]["InvoiceType"]);
obj.PONo = Convert.ToString(dt.Rows[0]["PONo"]);
obj.Supplier = Convert.ToString(dt.Rows[0]["Supplier"]);
return(obj);
}
else
{
return(new GRN_Payment());
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public long Add(GRN_Payment obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", obj.GRNNo),
new SqlParameter("@PONo", obj.PONo),
new SqlParameter("@InvoiceNo", obj.InvoiceNo),
new SqlParameter("@InvoiceType", obj.InvoiceType),
new SqlParameter("@Supplier", obj.Supplier)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_GRN_Payment", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void gvGRNList_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
objGRN = new GRN();
bindItemList.DataSource = null;
objGRN = objGRNDL.Get(Convert.ToInt64(gvGRNList.Rows[e.RowIndex].Cells["ColGRNNO"].Value));
if (objGRN != null)
{
bindItemList.DataSource = objGRNDL.GetDataView_Items(objGRN.GRNNo);
objGRN_Payment = objGRN_Payment_DL.GetByGRNNO(objGRN.GRNNo);
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
