public int AddPayer(Ent_Payer Payer)
{
int result = 0;
try
{
log.MethodLog(" public int InsertintoPayer(Ent_Payer Payer) method entry");
string Query = @"INSERT INTO dbo.Payer(
Payer_Name,Payer_Sub_Group_Name,Payer_Type,Address1,Address2,City,State,Zip_Code,Phone,Fax,Email,Contact_Person_Name,
Contact_Person_Designation,Mobile_Number,Website,Desk_Extn,Group_ID,Claim_Office_ID,
Payer_Medigap_Number,Status,Others,Attach_Forms_Type,ModifiedBy,ModifiedByDate) VALUES
(@Payer_Name,@Payer_Sub_Group_Name,@Payer_Type,@Address1,@Address2,@City,@State,@Zip_Code,@Phone,@Fax,@Email
,@Contact_Person_Name,@Contact_Person_Designation,@Mobile_Number,@Website,@Desk_Extn,@Group_Id,@Claim_Office_ID
,@Payer_Medigap_Number,@Status,@Others,@Attach_Forms_Type,@ModifiedBy,@ModifiedByDate)";
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, AddParameters(Payer));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public ActionResult Payer(Ent_Payer Payer)
{
Payer.ModifiedBy = Session["UserName"].ToString();
Payer.ModifiedByDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (Payer.Payer_ID == 0)
{
bll.AddPayer(Payer);
}
else
{
bll.UpdatePayer(Payer);
}
return(RedirectToAction("ViewAllPayer"));
}
public int UpdatePayer(Ent_Payer Payer)
{
int result = 0;
try
{
log.MethodLog("public int UpdatePayer(Ent_Payer Payer) method entry");
string Query = @"UPDATE [dbo].[Payer]
SET [Payer_Name] = @Payer_Name
,[Payer_Sub_Group_Name] = @Payer_Sub_Group_Name
,[Payer_Type] = @Payer_Type
,[Address1] = @Address1
,[Address2] = @Address2
,[City] = @City
,[State] = @State
,[Zip_Code] = @Zip_Code
,[Phone] = @Phone
,[Fax] = @Fax
,[Email] = @Email
,[Contact_Person_Name] = @Contact_Person_Name
,[Contact_Person_Designation] = @Contact_Person_Designation
,[Mobile_Number] =@Mobile_Number
,[WebSite] = @WebSite
,[Desk_Extn] = @Desk_Extn
,[Group_ID] = @Group_ID
,[Claim_Office_ID] = @Claim_Office_ID
,[Payer_Medigap_Number] = @Payer_Medigap_Number
,[Status] = @Status
,[Others] = @Others
,[Attach_Forms_Type] = @Attach_Forms_Type
,[ModifiedBy] = @ModifiedBy
,[ModifiedByDate] = @ModifiedByDate WHERE WHERE Payer_ID=@Payer_ID";
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, AddParameters(Payer));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public Ent_Payer EditPayer(int PayerId)
{
Ent_Payer result = null;
try
{
log.MethodLog(" public Ent_Payer EditPayer(int PayerId) method entry");
string Query = "SELECT * FROM dbo.Payer WHERE Payer_ID=@Payer_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Payer_ID", PayerId);
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQueryResult <Ent_Payer>(Query, param).FirstOrDefault();
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public DynamicParameters AddParameters(Ent_Payer Payer)
{
try
{
DynamicParameters param = new DynamicParameters();
param.Add("@Payer_ID", Payer.Payer_ID);
param.Add("@Payer_Name", Payer.Payer_Name);
param.Add("@Payer_Sub_Group_Name", Payer.Payer_Sub_Group_Name);
param.Add("@Payer_Type", Payer.Payer_Type);
param.Add("@Address1", Payer.Address1);
param.Add("@Address2", Payer.Address2);
param.Add("@City", Payer.City);
param.Add("@State", Payer.State);
param.Add("@Zip_Code", Payer.Zip_Code);
param.Add("@Phone", Payer.Phone);
param.Add("@Fax", Payer.Fax);
param.Add("@Email", Payer.Email);
param.Add("@Contact_Person_Name", Payer.Contact_Person_Name);
param.Add("@Contact_Person_Designation", Payer.Contact_Person_Designation);
param.Add("@Mobile_Number", Payer.Mobile_Number);
param.Add("@WebSite", Payer.WebSite);
param.Add("@Desk_Extn", Payer.Desk_Extn);
param.Add("@Group_ID", Payer.Group_ID);
param.Add("@Claim_Office_ID", Payer.Claim_Office_ID);
param.Add("@Payer_Medigap_Number", Payer.Payer_Medigap_Number);
param.Add("@Status", Payer.Status);
param.Add("@Others", Payer.Others);
param.Add("@Attach_Forms_Type", Payer.Attach_Forms_Type);
param.Add("@ModifiedBy", Payer.ModifiedBy);
param.Add("@ModifiedByDate", Payer.ModifiedByDate.ToShortDateString());
return(param);
}
catch (Exception)
{
throw;
}
}
