public int GetInsertDoctorsList(DoctorMissedReason.DoctorsDetailsList _ObjData, DataTable dtTable)
{
int result = 1;
int save = 0;
try
{
string cmdTxt = "SP_HD_Insert_DoctorsList";
SqlCommand command = new SqlCommand(cmdTxt);
command.CommandType = CommandType.StoredProcedure;
//var p = new DynamicParameters();
_objSPData.AddParamToSqlCommand(command, "@subDomainName", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.subDomainName);
_objSPData.AddParamToSqlCommand(command, "@Region_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.Region_Code);
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.Company_Code);
_objSPData.AddParamToSqlCommand(command, "@User_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.User_Code);
// _objSPData.AddParamToSqlCommand(command, "@UserCode", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjData.LoginUserCode);
//_objSPData.AddParamToSqlCommand(command, "@Norms_Visit_Count", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Actual_Visit_Count);
// _objSPData.AddParamToSqlCommand(command, "@Reason", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Reason);
//_objSPData.AddParamToSqlCommand(command, "@Remarks", ParameterDirection.Input, SqlDbType.VarChar, 1000, _ObjData.Remarks);
_objSPData.AddParamToSqlCommand(command, "@Status", ParameterDirection.Input, SqlDbType.Int, 8, _ObjData.Status);
_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, "@Result", ParameterDirection.Output, SqlDbType.Int, 8, "");
if (dtTable != null)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_Insert_Doctors_Data", ParameterDirection.Input, SqlDbType.Structured, dtTable, "TVP_Insert_Doctors_Data");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_Insert_Doctors_Data", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_Insert_Doctors_Data");
}
_objData.ExecuteNonQuery(command, _ObjData.subDomainName);
result = Convert.ToInt32(command.Parameters["@Result"].Value);
}
catch (Exception ex)
{
throw;
}
return(result);
}
public int GetInsertDoctorsList(DoctorMissedReason.DoctorsDetailsList _ObjData)
{
DataTable dtTable = new DataTable();
dtTable.Columns.Add("Region_Code", typeof(string));
dtTable.Columns.Add("Customer_Code", typeof(string));
dtTable.Columns.Add("Customer_Name", typeof(string));
dtTable.Columns.Add("Reason", typeof(string));
dtTable.Columns.Add("Remarks", typeof(string));
//dtTable.Columns.Add("Month", typeof(int));
//dtTable.Columns.Add("Year", typeof(int));
if (_ObjData.lstProductSales != null && _ObjData.lstProductSales.Count > 0)
{
for (int i = 0; i < _ObjData.lstProductSales.Count(); i++)
{
dtTable.Rows.Add(_ObjData.Region_Code, _ObjData.lstProductSales[i].Customer_Code, _ObjData.lstProductSales[i].Customer_Name, _ObjData.lstProductSales[i].Reason, _ObjData.lstProductSales[i].Remarks);
}
}
return(_objDL_MissedDoctorsEntry.GetInsertDoctorsList(_ObjData, dtTable));
}
public int GetInsertDoctorsList(DoctorMissedReason.DoctorsDetailsList _ObjData)
{
return(_objBL_MissedDoctorsEntry.GetInsertDoctorsList(_ObjData));
}
