public JsonResult InsertBeatPlanDetails(string companyCode, string regionCode, string _ObjBeatData, int Weeknumber, string Weekday)
{
OutPutJsonBeatModel result = new OutPutJsonBeatModel();
BeatPlanModel _objDetailsBeat = new BeatPlanModel();
string companyId = "";
companyId = _objCurrentInfo.GetCompanyId();
int CompanyId = Convert.ToInt32(companyId);
_objDetailsBeat = (BeatPlanModel)JsonConvert.DeserializeObject(_ObjBeatData, typeof(BeatPlanModel));
result = _ObjBeat.InsertBeatPlanDetails(companyCode, regionCode, CompanyId, _objDetailsBeat, Weeknumber, Weekday);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public OutPutJsonBeatModel UpdateBeatPlanDetails(string companyCode, string regionCode, BeatPlanModel _ObjBeatData, DataTable dtSFC, DataTable dtWorkArea, int Weeknumber, string Weekday)
{
bool result = false;
_objSPData = new SPData();
_objData = new Data();
OutPutJsonBeatModel output = new OutPutJsonBeatModel();
long BeatCodeHistory = GetSeqNumber("SEQ_tbl_SFA_Camp_Planner_Header_History");
string response = string.Empty;
try
{
SqlCommand command = new SqlCommand(SP_HD_BPP_UPDATEBEATPLANDETAILS);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
_objSPData.AddParamToSqlCommand(command, "@BeatName", ParameterDirection.Input, SqlDbType.VarChar, 1000, _ObjBeatData.Beat_Name);
_objSPData.AddParamToSqlCommand(command, "@BeatCode", ParameterDirection.Input, SqlDbType.VarChar, 100, _ObjBeatData.Beat_Code);
_objSPData.AddParamToSqlCommand(command, "@HistoryBeatCode", ParameterDirection.Input, SqlDbType.VarChar, 100, BeatCodeHistory);
_objSPData.AddParamToSqlCommand(command, "@WorKArea", ParameterDirection.Input, SqlDbType.VarChar, 8000, _ObjBeatData.Work_Area);
_objSPData.AddParamToSqlCommand(command, "@Work_Category_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, _ObjBeatData.Work_Category_Code);
_objSPData.AddParamToSqlCommand(command, "@Work_Category_Name", ParameterDirection.Input, SqlDbType.VarChar, 1000, _ObjBeatData.Work_Category_Name);
_objSPData.AddParamToSqlCommand(command, "@Created_By", ParameterDirection.Input, SqlDbType.VarChar, 100, _ObjBeatData.Created_By);
_objSPData.AddParamToSqlCommand(command, "@WeekNumber", ParameterDirection.Input, SqlDbType.Int, 8, Weeknumber);
_objSPData.AddParamToSqlCommand(command, "@WeekDay", ParameterDirection.Input, SqlDbType.VarChar, 30, Weekday);
if (dtSFC.Rows.Count > 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_BPP_InsertBeatSFCDetails", ParameterDirection.Input, SqlDbType.Structured, dtSFC, "TVP_BPP_InsertBeatSFCDetails");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_BPP_InsertBeatSFCDetails", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_BPP_InsertBeatSFCDetails");
}
if (dtSFC.Rows.Count > 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_BPP_InsertBeatWADetails", ParameterDirection.Input, SqlDbType.Structured, dtWorkArea, "TVP_BPP_InsertBeatWADetails");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_BPP_InsertBeatWADetails", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_BPP_InsertBeatWADetails");
}
_objSPData.AddParamToSqlCommand(command, "@Result", ParameterDirection.Output, SqlDbType.VarChar, 8000, "");
_objData.OpenConnection();
_objData.ExecuteNonQuery(command);
response = Convert.ToString(command.Parameters["@Result"].Value);
if (!(response.Contains("INFO")))
{
output.Status_Message = true;
output.Message = "Success:Successfully Updated Beat/Patch Plan.";
}
else
{
output.Status_Message = false;
output.Message = response;
}
}
catch (Exception ex)
{
throw;
}
return(output);
}
public OutPutJsonBeatModel InsertBeatPlanDetails(string companyCode, string regionCode, int CompanyId, BeatPlanModel _ObjBeatData, int Weeknumber, string Weekday)
{
OutPutJsonBeatModel result = new OutPutJsonBeatModel();
try
{
DataTable dtSFC = new DataTable();
dtSFC.Columns.Add("Company_Code", typeof(string));
dtSFC.Columns.Add("Company_Id", typeof(int));
dtSFC.Columns.Add("Region_Code", typeof(string));
dtSFC.Columns.Add("From_Region_Name", typeof(string));
dtSFC.Columns.Add("To_Region_Name", typeof(string));
dtSFC.Columns.Add("Distance_Fare_Code", typeof(string));
dtSFC.Columns.Add("Route_Way", typeof(string));
dtSFC.Columns.Add("Travel_Mode", typeof(string));
dtSFC.Columns.Add("Created_By", typeof(string));
if (_ObjBeatData.lst_SFCDetails != null && _ObjBeatData.lst_SFCDetails.Count > 0)
{
for (int i = 0; i < _ObjBeatData.lst_SFCDetails.Count; i++)
{
dtSFC.Rows.Add(companyCode, CompanyId, _ObjBeatData.lst_SFCDetails[i].Region_Code, _ObjBeatData.lst_SFCDetails[i].From_Region_Name,
_ObjBeatData.lst_SFCDetails[i].To_Region_Name, _ObjBeatData.lst_SFCDetails[i].Distance_Fare_Code,
_ObjBeatData.lst_SFCDetails[i].Route_Way, _ObjBeatData.lst_SFCDetails[i].Travel_Mode, _ObjBeatData.lst_SFCDetails[i].Created_By);
}
}
DataTable dtWorkArea = new DataTable();
dtWorkArea.Columns.Add("Company_Code", typeof(string));
dtWorkArea.Columns.Add("Company_Id", typeof(string));
dtWorkArea.Columns.Add("Work_Area_Name", typeof(string));
dtWorkArea.Columns.Add("Region_Code", typeof(string));
dtWorkArea.Columns.Add("Created_By", typeof(string));
if (_ObjBeatData.lst_WorkArea != null && _ObjBeatData.lst_WorkArea.Count > 0)
{
for (int i = 0; i < _ObjBeatData.lst_WorkArea.Count; i++)
{
dtWorkArea.Rows.Add(companyCode, CompanyId, _ObjBeatData.lst_WorkArea[i].Work_Area, _ObjBeatData.lst_WorkArea[i].Region_Code,
_ObjBeatData.lst_WorkArea[i].Created_By);
}
}
if (_ObjBeatData.Mode.ToUpper() == "INSERT")
{
result = _objBeat.InsertBeatPlanDetails(companyCode, regionCode, _ObjBeatData, dtSFC, dtWorkArea, Weeknumber, Weekday);
}
else
{
result = _objBeat.UpdateBeatPlanDetails(companyCode, regionCode, _ObjBeatData, dtSFC, dtWorkArea, Weeknumber, Weekday);
}
}
catch (Exception ex)
{
throw;
}
return(result);
}
