/// <summary>
/// Saves a record to the T_CustomerItemAlloc table.
/// </summary>
public Boolean Savet_CustomerItemAllocSP(T_CustomerItemAlloc t_CustomerItemAlloc, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CustomerItemAllocSave";
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_CustomerItemAlloc.Customer;
scom.Parameters.Add("@Item", SqlDbType.VarChar, 20).Value = t_CustomerItemAlloc.Item;
scom.Parameters.Add("@AllocQTY", SqlDbType.Decimal, 9).Value = t_CustomerItemAlloc.AllocQTY;
scom.Parameters.Add("@DateFrom", SqlDbType.DateTime, 8).Value = t_CustomerItemAlloc.DateFrom;
scom.Parameters.Add("@Dateto", SqlDbType.DateTime, 8).Value = t_CustomerItemAlloc.Dateto;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = t_CustomerItemAlloc.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_CustomerItemAlloc.Datex;
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_CustomerItemAlloc> SelectT_CustomerItemAllocMulti(T_CustomerItemAlloc objt_CustomerItemAlloc2)
{
List <T_CustomerItemAlloc> retval = new List <T_CustomerItemAlloc>();
try
{
strquery = @"select * from t_CustomerItemAlloc where purchaseReqNo = '" + objt_CustomerItemAlloc2.Item + "'";
DataTable dtt_CustomerItemAlloc = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtt_CustomerItemAlloc.Rows)
{
if (drType != null)
{
T_CustomerItemAlloc objt_CustomerItemAlloc = new T_CustomerItemAlloc();
objt_CustomerItemAlloc.Customer = drType["Customer"].ToString();
objt_CustomerItemAlloc.Item = drType["Item"].ToString();
objt_CustomerItemAlloc.AllocQTY = decimal.Parse(drType["AllocQTY"].ToString());
objt_CustomerItemAlloc.DateFrom = DateTime.Parse(drType["DateFrom"].ToString());
objt_CustomerItemAlloc.Dateto = DateTime.Parse(drType["Dateto"].ToString());
objt_CustomerItemAlloc.Userx = drType["Userx"].ToString();
objt_CustomerItemAlloc.Datex = DateTime.Parse(drType["Datex"].ToString());
retval.Add(objt_CustomerItemAlloc);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
private void txt_qty_KeyDown(object sender, KeyEventArgs e)
{
errorProvider1.Clear();
try
{
if (e.KeyCode == Keys.Enter)
{
if (txt_code.Text.Trim() != "")
{
if (txt_qty.Text.Trim() != "")
{
try
{
T_CustomerItemAlloc all = new T_CustomerItemAlloc();
all.Customer = txt_customer.Text.Trim();
all.Item = txt_code.Text.Trim();
all.DateFrom = dte_datefrom.Value;
all.Dateto = dte_dateto.Value;
all.Datex = DateTime.Now;
all.Userx = commonFunctions.Loginuser;
all.AllocQTY = commonFunctions.ToDecimal(txt_qty.Text.Trim());
new T_CustomerItemAllocDL().Savet_CustomerItemAllocSP(all, 1);
LoadData();
}
catch (Exception ex)
{
errorProvider1.SetError(txt_customer, "Allocation details already exists...");
errorProvider1.SetError(txt_code, "Allocation details already exists...");
commonFunctions.SetMDIStatusMessage("Allocation details already exists...", 1);
}
}
}
else
{
errorProvider1.SetError(txt_qty, "Please enter item code");
commonFunctions.SetMDIStatusMessage("Please enter item code", 1);
}
txt_code.Focus();
}
}
catch (Exception ex)
{
LogFile.WriteErrorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, this.Name, ex.Message.ToString(), "Exception");
commonFunctions.SetMDIStatusMessage("Genaral Error on loading data", 1);
}
}
public T_CustomerItemAlloc Selectt_CustomerItemAlloc(T_CustomerItemAlloc objt_CustomerItemAlloc)
{
try
{
strquery = @"select * from t_CustomerItemAlloc where CompCode = '" + objt_CustomerItemAlloc + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objt_CustomerItemAlloc.Customer = drType["Customer"].ToString();
objt_CustomerItemAlloc.Item = drType["Item"].ToString();
objt_CustomerItemAlloc.AllocQTY = decimal.Parse(drType["AllocQTY"].ToString());
objt_CustomerItemAlloc.DateFrom = DateTime.Parse(drType["DateFrom"].ToString());
objt_CustomerItemAlloc.Dateto = DateTime.Parse(drType["Dateto"].ToString());
objt_CustomerItemAlloc.Userx = drType["Userx"].ToString();
objt_CustomerItemAlloc.Datex = DateTime.Parse(drType["Datex"].ToString());
return(objt_CustomerItemAlloc);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
