public int GetUpdateProductSales(PSAndSSSalesEntry.PPAndSS _ObjData)
{
DataTable dtTable = new DataTable();
dtTable.Columns.Add("Company_Id", typeof(int));
dtTable.Columns.Add("User_Code", typeof(string));
dtTable.Columns.Add("Product_Code", typeof(string));
dtTable.Columns.Add("Product_Name", typeof(string));
dtTable.Columns.Add("Units", typeof(decimal));
dtTable.Columns.Add("Closing", typeof(decimal));
dtTable.Columns.Add("Sales_Id", typeof(int));
dtTable.Columns.Add("Transit", typeof(decimal));
dtTable.Columns.Add("Price_Per_Unit", typeof(decimal));
if (_ObjData.lstProductSales != null && _ObjData.lstProductSales.Count > 0)
{
for (int i = 0; i < _ObjData.lstProductSales.Count(); i++)
{
dtTable.Rows.Add(_ObjData.CompanyId, _ObjData.User_Code, _ObjData.lstProductSales[i].Product_Code,
_ObjData.lstProductSales[i].Product_Name, _ObjData.lstProductSales[i].Units,
_ObjData.lstProductSales[i].Closing, _ObjData.lstProductSales[i].Sales_Id,
_ObjData.lstProductSales[i].Transit, _ObjData.lstProductSales[i].Price_Per_Unit);
}
}
return(_objDL_PSAndSSSalesEntry.GetUpdateProductSales(_ObjData, dtTable));
}
public int GetMultipleEntityStatusChange(DataTable dtTable, PSAndSSSalesEntry.PPAndSS _ObjData)
{
int rowsAffected = 0;
try
{
string cmdTxt = "Sp_hd_PS_SSEntityStatusMultipleChange";
SqlCommand command = new SqlCommand(cmdTxt);
command.CommandType = CommandType.StoredProcedure;
// _objSPData.AddParamToSqlCommand(command, "@value", ParameterDirection.Input, SqlDbType.VarChar, 10, value);
if (dtTable != null)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PS_SS_Sales", ParameterDirection.Input, SqlDbType.Structured, dtTable, "TVP_PS_SS_Sales");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PS_SS_Sales", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_PS_SS_Sales");
}
_objData.OpenConnection();
_objData.ExecuteNonQuery(command, _ObjData.subDomainName);
rowsAffected = 1;
//connection.Close();
}
catch (Exception ex)
{
throw;
}
return(rowsAffected);
}
public int GetEntityStatusChange(PSAndSSSalesEntry.PPAndSS _ObjData)
{
//_objBatch.User_Code = _obj.User_Code;
//_objBatch.subDomainName = _obj.subDomainName;
//_objBatch.Sales_Id = _obj.Sales_Id;
//_objBatch.Remark = _obj.Remark;
return(_objBL_PsAndSSSalesEntry.GetEntityStatusChange(_ObjData));
}
public int GetUpdateProductSales(PSAndSSSalesEntry.PPAndSS _ObjData)
{
//_objBatch.Region_Code = _ObjData.Region_Code;
//_objBatch.EntityCode = _ObjData.EntityCode;
//_objBatch.Entity = _ObjData.Entity;
//_objBatch.Month = _ObjData.Month;
//_objBatch.Year = _ObjData.Year;
//_objBatch.Date = _ObjData.Date;
//_objBatch.EntityName = _ObjData.EntityName;
//_objBatch.Sales_Id = _ObjData.Sales_Id;
//_objBatch.lstProductSales = _ObjData.lstProductSales;
//_objBatch.User_Code = _ObjData.User_Code;
//_objBatch.CompanyId = _ObjData.CompanyId;
//_objBatch.TypeOfMapping = _ObjData.TypeOfMapping;
//_objBatch.subDomainName = _ObjData.subDomainName;
return(_objBL_PsAndSSSalesEntry.GetUpdateProductSales(_ObjData));
}
public int GetMultipleEntityStatusChange(PSAndSSSalesEntry.PPAndSS _objData)
{
DataTable dtTable = new DataTable();
dtTable.Columns.Add("User_Code", typeof(string));
dtTable.Columns.Add("Sales_Id", typeof(int));
dtTable.Columns.Add("Remark", typeof(string));
if (_objData.lstSaleEntity != null && _objData.lstSaleEntity.Count > 0)
{
for (int i = 0; i < _objData.lstSaleEntity.Count(); i++)
{
dtTable.Rows.Add(_objData.User_Code, _objData.lstSaleEntity[i].Sales_Id, _objData.lstSaleEntity[i].Remark);
}
}
return(_objDL_PSAndSSSalesEntry.GetMultipleEntityStatusChange(dtTable, _objData));
}
public int GetUpdateProductSales(PSAndSSSalesEntry.PPAndSS _ObjData, DataTable dtTable)
{
int result = 1;
int save = 0;
//List<Batch.ProductInsert> obj = JsonConvert.DeserializeObject<List<Batch.ProductInsert>>(_batch.Product).ToList();
try
{
string cmdTxt = "SP_HD_PP_SSSales_Update";
SqlCommand command = new SqlCommand(cmdTxt);
command.CommandType = CommandType.StoredProcedure;
//var p = new DynamicParameters();
_objSPData.AddParamToSqlCommand(command, "@Region_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.Region_Code);
_objSPData.AddParamToSqlCommand(command, "@EntityCode", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.EntityCode);
_objSPData.AddParamToSqlCommand(command, "@Entity", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.Entity);
_objSPData.AddParamToSqlCommand(command, "@Month", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Month);
_objSPData.AddParamToSqlCommand(command, "@Year", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Year);
_objSPData.AddParamToSqlCommand(command, "@Date", ParameterDirection.Input, SqlDbType.DateTime, 30, _ObjData.Date);
_objSPData.AddParamToSqlCommand(command, "@CompanyId", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.CompanyId);
_objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.User_Code);
_objSPData.AddParamToSqlCommand(command, "@EntityName", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.EntityName);
_objSPData.AddParamToSqlCommand(command, "@TypeOfMapping", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.TypeOfMapping);
_objSPData.AddParamToSqlCommand(command, "@Sales_Id", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Sales_Id);
_objSPData.AddParamToSqlCommand(command, "@Result", ParameterDirection.Output, SqlDbType.Int, 8, "");
if (dtTable != null)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PP_SS_Insert_Products", ParameterDirection.Input, SqlDbType.Structured, dtTable, "TVP_PP_SS_Insert_Products");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_PP_SS_Insert_Products", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_PP_SS_Insert_Products");
}
//_objData.OpenConnection();
_objData.ExecuteNonQuery(command, _ObjData.subDomainName);
result = Convert.ToInt32(command.Parameters["@Result"].Value);
}
catch (Exception ex)
{
throw;
}
return(result);
}
public int GetEntityStatusChange(PSAndSSSalesEntry.PPAndSS _ObjData)
{
int result = 1;
try
{
using (IDbConnection connection = IDbOpenConnectionCompanyWise(_ObjData.subDomainName))
{
var par = new DynamicParameters();
par.Add("@User_Code", _ObjData.User_Code);
par.Add("@Sales_Id", _ObjData.Sales_Id);
par.Add("@Remark", _ObjData.Remark);
result = connection.Query <int>("Sp_hd_PP_SSStatusChange", par, commandType: CommandType.StoredProcedure).SingleOrDefault();
connection.Close();
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
public int GetMultipleEntityStatusChange(PSAndSSSalesEntry.PPAndSS _ObjData)
{
//_objBatch.lstSaleEntity = _obj.lstSaleEntity;
//_objBatch.Remark = _obj.Remark;
return(_objBL_PsAndSSSalesEntry.GetMultipleEntityStatusChange(_ObjData));
}
public int GetEntityStatusChange(PSAndSSSalesEntry.PPAndSS _ObjData)
{
return(_objDL_PSAndSSSalesEntry.GetEntityStatusChange(_ObjData));
}
