public List <dynamic> GetActivityData(ActivityDetailsUI activityData)
{
List <dynamic> objDynamic = new List <dynamic>();
string insertProcedure = "[Get_BranchMasterByID]";
Dictionary <string, string> input_parameters = new Dictionary <string, string>();
input_parameters.Add("@Pkey_activity_id", 1 + "#bigint#" + activityData.Pkey_activity_id);
DataSet ds = obj.SelectSql(insertProcedure, input_parameters);
var myEnumerable = ds.Tables[0].AsEnumerable();
List <ActivityDetailsUI> ordtl =
(from item in myEnumerable
select new ActivityDetailsUI
{
activity_name = item.Field <String>("activity_name"),
branch_id = item.Field <Int64>("branch_id"),
city_id = item.Field <Int64>("city_id"),
state_id = item.Field <Int64>("city_id"),
}).ToList();
objDynamic.Add(ordtl);
return(objDynamic);
}
public JsonResult GetActivitydetailData(ActivityDetailsUI activityDetailsUI)
{
ActivityDetailsData activityDetailsData = new ActivityDetailsData();
var Data = activityDetailsData.GetActivityData(activityDetailsUI);
return(new JsonResult {
Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult AddActivityData(ActivityDetailsUI activityDetailsUI)
{
IActivityDetails activityDetailsData = new ActivityDetailsData();
try
{
var Data = activityDetailsData.AddActivity(activityDetailsUI);
return(new JsonResult {
Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
return(new JsonResult {
Data = "", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
List <dynamic> IActivityDetails.AddActivity(ActivityDetailsUI activityDetailsUI)
{
String insertProcedure = "[CRUD_ActivityMaster]";
Dictionary <string, string> input_parameters = new Dictionary <string, string>();
input_parameters.Add("@Pkey_activity_id", 1 + "#bigint#" + activityDetailsUI.Pkey_activity_id);
input_parameters.Add("@activity_name", 1 + "#varchar#" + activityDetailsUI.activity_name);
input_parameters.Add("@branch_id", 1 + "#bigint#" + activityDetailsUI.branch_id);
input_parameters.Add("@city_id", 1 + "#bigint#" + activityDetailsUI.city_id);
input_parameters.Add("@state_id", 1 + "#bigint#" + activityDetailsUI.state_id);
input_parameters.Add("@UserID ", 1 + " #bigint# " + activityDetailsUI.UserID);
input_parameters.Add("@IsDeleted ", 1 + "#int#" + activityDetailsUI.IsDeleted);
input_parameters.Add("@Type", 1 + "#int#" + activityDetailsUI.Type);
input_parameters.Add("@Pkey_activity_idout", 2 + "#int#" + null);
input_parameters.Add("@ReturnValue", 2 + "#int#" + null);
return(obj.SqlCRUD(insertProcedure, input_parameters));
}
