/// <summary>
/// Method to Insert Purchase Requisition Form
/// </summary>
/// <param name="companyCode"></param>
/// <param name="companyId"></param>
/// <param name="ObjPurchaseRequisitionModel"></param>
/// <param name="ProductTable"></param>
/// <param name="AlertTable"></param>
/// <param name="createdBy"></param>
/// <returns></returns>
public bool InsertPurchaseRequisition(string companyCode, int companyId, PurchaseRequisitionModel ObjPurchaseRequisitionModel, DataTable ProductTable, DataTable AlertTable, string createdBy, string regionCode)
{
bool result = false;
_objSPData = new SPData();
_objData = new Data();
try
{
string cmdText = "SP_HD_PRM_InserPurchaseRequisitionForm";
SqlCommand command = new SqlCommand(cmdText);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@Campaign_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, ObjPurchaseRequisitionModel.Campaign_Code);
_objSPData.AddParamToSqlCommand(command, "@Requisition_By", ParameterDirection.Input, SqlDbType.VarChar, 30, ObjPurchaseRequisitionModel.Requisition_By);
_objSPData.AddParamToSqlCommand(command, "@Requisition_Date", ParameterDirection.Input, SqlDbType.DateTime, 30, ObjPurchaseRequisitionModel.Requisition_Date);
if (ObjPurchaseRequisitionModel.Objective == null)
{
_objSPData.AddParamToSqlCommand(command, "@Objective", ParameterDirection.Input, SqlDbType.VarChar, 500, "");
}
else
{
_objSPData.AddParamToSqlCommand(command, "@Objective", ParameterDirection.Input, SqlDbType.VarChar, 500, ObjPurchaseRequisitionModel.Objective);
}
_objSPData.AddParamToSqlCommand(command, "@Company_Id", ParameterDirection.Input, SqlDbType.Int, 8, companyId);
_objSPData.AddParamToSqlCommand(command, "@Created_By", ParameterDirection.Input, SqlDbType.VarChar, 30, createdBy);
if (ProductTable.Rows.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PR_Product", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_PR_Product");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PR_Product", ParameterDirection.Input, SqlDbType.Structured, ProductTable, "TVP_PR_Product");
}
if (AlertTable.Rows.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PR_Alert", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_PR_Alert");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PR_Alert", ParameterDirection.Input, SqlDbType.Structured, AlertTable, "TVP_PR_Alert");
}
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objData.OpenConnection();
_objData.ExecuteNonQuery(command);
result = true;
}
catch (Exception ex)
{
throw;
}
finally
{
_objData.CloseConnection();
}
return(result);
}
/// <summary>
/// Method to Insert Purchase Requisition Form
/// </summary>
/// <param name="ObjPurchaseRequisitionModel"></param>
/// <returns></returns>
public bool InsertPurchaseRequisition(PurchaseRequisitionModel ObjPurchaseRequisitionModel)
{
bool result = false;
string companyCode = null;
int companyId = 0;
string companyid = null;
string createdBy = null;
string regionCode = null;
try
{
companyCode = ObjCurrInfo.GetCompanyCode();
companyid = ObjCurrInfo.GetCompanyId();
Int32.TryParse(companyid, out companyId);
createdBy = ObjCurrInfo.GetUserCode();
regionCode = ObjCurrInfo.GetRegionCode();
result = ObjPR.InsertPurchaseRequisition(companyCode, companyId, createdBy, ObjPurchaseRequisitionModel, regionCode);
}catch (Exception ex)
{
throw;
}
return(result);
}
/// <summary>
/// Method to Insert Purchase Requisition Form
/// </summary>
/// <param name="ObjPurchaseRequisitionModel"></param>
/// <returns></returns>
public bool InsertPurchaseRequisition(string companyCode, int companyId, string createdBy, PurchaseRequisitionModel ObjPurchaseRequisitionModel, string regionCode)
{
bool result = false;
try
{
DataTable ProductTable = null;
if (ObjPurchaseRequisitionModel.lstProd.Count > 0)
{
ProductTable = new DataTable();
ProductTable.Columns.Add("CompanyCode", typeof(string));
ProductTable.Columns.Add("Requisition_Details_Id", typeof(int));
ProductTable.Columns.Add("Product_Code", typeof(string));
ProductTable.Columns.Add("Quantity", typeof(int));
ProductTable.Columns.Add("Remarks", typeof(string));
ProductTable.Columns.Add("Record_Status", typeof(int));
ProductTable.Columns.Add("Acknowledge_Status", typeof(int));
ProductTable.Columns.Add("Company_Id", typeof(int));
ProductTable.Columns.Add("Created_By", typeof(string));
for (int i = 0; i < ObjPurchaseRequisitionModel.lstProd.Count; i++)
{
ProductTable.Rows.Add(companyCode, ObjPurchaseRequisitionModel.lstProd[i].RowId, ObjPurchaseRequisitionModel.lstProd[i].Sample_Product, ObjPurchaseRequisitionModel.lstProd[i].Quantity,
ObjPurchaseRequisitionModel.lstProd[i].Remarks, 2, 0, companyId, createdBy);
}
}
DataTable AlertTable = null;
if (ObjPurchaseRequisitionModel.lstProd.Count > 0)
{
AlertTable = new DataTable();
AlertTable.Columns.Add("CompanyCode", typeof(string));
AlertTable.Columns.Add("Requisition_Details_Id", typeof(int));
AlertTable.Columns.Add("Purchase_Procurement_Date", typeof(string));
AlertTable.Columns.Add("PPD_Notification_Days", typeof(int));
AlertTable.Columns.Add("Dispatch_Date", typeof(string));
AlertTable.Columns.Add("DD_Notification_Days", typeof(int));
AlertTable.Columns.Add("Acknowledgement_Date", typeof(string));
AlertTable.Columns.Add("AD_Notification_Days", typeof(int));
AlertTable.Columns.Add("Record_Status", typeof(int));
AlertTable.Columns.Add("Company_Id", typeof(int));
AlertTable.Columns.Add("Created_By", typeof(string));
for (int j = 0; j < ObjPurchaseRequisitionModel.lstProd.Count; j++)
{
AlertTable.Rows.Add(companyCode, ObjPurchaseRequisitionModel.lstProd[j].RowId, ObjPurchaseRequisitionModel.lstProd[j].Purchase_Procurement_Date,
ObjPurchaseRequisitionModel.lstProd[j].PPD_Notification_Days, ObjPurchaseRequisitionModel.lstProd[j].Dispatch_Date,
ObjPurchaseRequisitionModel.lstProd[j].DD_Notification_Days, ObjPurchaseRequisitionModel.lstProd[j].Acknowledgement_Date,
ObjPurchaseRequisitionModel.lstProd[j].AD_Notification_Days, 2, companyId, createdBy);
}
}
result = ObjPR.InsertPurchaseRequisition(companyCode, companyId, ObjPurchaseRequisitionModel, ProductTable, AlertTable, createdBy, regionCode);
}
catch (Exception ex)
{
throw;
}
return(result);
}
