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 int AddProvider(Ent_Provider Provider)
{
int result = 0;
try
{
log.MethodLog(" public int InsertintoProvider(Ent_Provider Provider) method entry");
string Query = @"INSERT INTO dbo.Provider (
Facility_ID,Provider_Last_Name,Provider_First_Name,Provider_Middle_Name,Provider_Category,Working_Type,NPI
,Speciality,Home_Phone,Cell_Number,Fax_Number,Email_ID,Specialty_License_ID,State_License_ID,Anesthesia_ID,UPIN_ID,Blue_Cross_ID,Champus_ID,Address1,Address2,City,State
,Zip_Code,Country,Birth_Place,Date_Of_Birth,On_Board_Date,Relieving_Date,State_License_Effective_Date,DEA_Number,DEA_Effective_Date,CAQH_ID_Number
,Professional_Experience,Status,Others,PECO,ModifiedBy,ModifiedByDate)
VALUES
(@Facility_ID,@Provider_Last_Name,@Provider_First_Name,@Provider_Middle_Name,@Provider_Category,@Working_Type,@NPI,@Speciality,@Home_Phone,@Cell_Number,
@Fax_Number,@Email_ID,@Specialty_License_ID,@State_License_ID,@Anesthesia_ID,@UPIN_ID,@Blue_Cross_ID,@Champus_ID,@Address1,@Address2,@City,@State,
@Zip_Code,@Country,@Birth_Place,@Date_Of_Birth,@On_Board_Date,@Relieving_Date,@State_License_Effective_Date,@DEA_Number,@DEA_Effective_Date,@CAQH_ID_Number,
@Professional_Experience,@Status,@Others,@PECO,@ModifiedBy,@ModifiedByDate)";
result = AtomORM.ExecuteQuery(Query, AssignParameters(Provider));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public int UpdateProvider(Ent_Provider Provider)
{
int result = 0;
try
{
log.MethodLog("public int UpdateProvider(Ent_Provider Provider) method entry");
string Query = @"UPDATE dbo.Provider SET
Facility_ID=@Facility_ID,Provider_Last_Name=@Provider_Last_Name,Provider_First_Name=@Provider_First_Name,
Provider_Middle_Name=@Provider_Middle_Name,Provider_Category=@Provider_Category,Working_Type=@Working_Type,NPI=@NPI
,Speciality=@Speciality,Home_Phone=@Home_Phone,Cell_Number=@Cell_Number,Fax_Number=@Fax_Number,Email_ID=@Email_ID
,Specialty_License_ID=@Specialty_License_ID,State_License_ID=@State_License_ID,Anesthesia_ID=@Anesthesia_ID
,UPIN_ID=@UPIN_ID,Blue_Cross_ID=@Blue_Cross_ID,Champus_ID=@Champus_ID,Address1=@Address1,Address2=@Address2,City=@City,State=@State
,Zip_Code=@Zip_Code,Country=@Country,Birth_Place=@Birth_Place,Date_Of_Birth=@Date_Of_Birth,On_Board_Date=@On_Board_Date
,Relieving_Date=@Relieving_Date,State_License_Effective_Date=@State_License_Effective_Date
,DEA_Number=@DEA_Number,DEA_Effective_Date=@DEA_Effective_Date,CAQH_ID_Number=@CAQH_ID_Number
,Professional_Experience=@Professional_Experience,Status=@Status,Others=@Others,PECO=@PECO,
ModifiedBy=@ModifiedBy,ModifiedByDate=@ModifiedByDate WHERE Provider_ID=@Provider_ID";
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, AssignParameters(Provider));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public ActionResult AddorEdit(int id = 0)
{
DynamicParameters parm = new DynamicParameters();
parm.Add("@EmployeeID", id);
//return View(AtomORM.ExecuteProceduresReturnList<Ent_Employee>("EmployeeViesByID", parm).FirstOrDefault());
return(View(AtomORM.ExecuteQueryResult <Ent_Employee>("SELECT * FROM Employee WHERE EmployeeID=@EmployeeID", parm).FirstOrDefault()));
}
public ActionResult Delete(int id)
{
DynamicParameters parm = new DynamicParameters();
parm.Add("@EmployeeID", id);
AtomORM.ExecuteProceduresWithoutReturn("EmployeeDeleteByID", parm);
return(RedirectToAction("ViewAll"));
}
public ActionResult AddorEdit(Ent_Employee emp)
{
DynamicParameters parm = new DynamicParameters();
parm.Add("@EmployeeID", emp.EmployeeID);
parm.Add("@EmployeeName", emp.EmployeeName);
parm.Add("@EmployeeAddress", emp.EmployeeAddress);
parm.Add("@EmployeeGender", emp.EmployeeGender);
AtomORM.ExecuteProceduresWithoutReturn("proemployee", parm);
return(RedirectToAction("ViewAll"));
}
public int AddComapny(Ent_Company Company)
{
int result = 0;
try
{
log.MethodLog(" public int InsertintoEnterprise(Ent_Company Company) method entry");
string Query = @"INSERT INTO [dbo].[Company]
([Enterprise_ID],[Company_Name],[Organization_Type],[Taxonomy_Speciality],[Address1],[Address2],[City],[State],
[Zip_Code],[Country],[Phone] ,[Fax],[Email] ,[Website],[Payto_Address],[Payto_City],[Payto_State] ,[Payto_Zip_Code]
,[Tax_Id],[NPI] ,[ModifiedBy],[ModifiedByDate])
VALUES
(@Enterprise_ID,@Company_Name, @Organization_Type, @Taxonomy_Speciality, @Address1, @Address2,@City,
@State,@Zip_Code,@Country,@Phone,@Fax,@Email,
@Website,@Payto_Address,@Payto_City,@Payto_State, @Payto_Zip_Code,@Tax_Id,@NPI,@ModifiedBy, @ModifiedByDate)" ;
DynamicParameters param = new DynamicParameters();
param.Add("@Enterprise_ID", Company.Enterprise_ID == 0?1: Company.Enterprise_ID);
param.Add("@Company_Name", Company.Company_Name);
param.Add("@Organization_Type", Company.Organization_Type);
param.Add("@Taxonomy_Speciality", Company.Taxonomy_Speciality);
param.Add("@Address1", Company.Address1);
param.Add("@Address2", Company.Address2);
param.Add("@City", Company.City);
param.Add("@State", Company.State);
param.Add("@Zip_Code", Company.Zip_Code);
param.Add("@Country", Company.Country);
param.Add("@Phone", Company.Phone);
param.Add("@Fax", Company.Fax);
param.Add("@Email", Company.Email);
param.Add("@Website", Company.Website);
param.Add("@Payto_Address", Company.Payto_Address);
param.Add("@Payto_City", Company.Payto_City);
param.Add("@Payto_State", Company.Payto_State);
param.Add("@Payto_Zip_Code", Company.Payto_Zip_Code);
param.Add("@Tax_Id", Company.Tax_Id);
param.Add("@NPI", Company.NPI);
param.Add("@ModifiedBy", Company.ModifiedBy);
param.Add("@ModifiedByDate", Company.ModifiedByDate.ToShortDateString());
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, param);
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public int AddEnterprise(Ent_Enterprise Enterprise)
{
int result = 0;
try
{
log.MethodLog(" public int InsertintoEnterprise(Ent_Enterprise Enterprise) method entry");
string Query = @"INSERT INTO [dbo].[Enterprise]
([Enterprise_Name],[Organization_Type] ,[Owner_Last_Name],[Owner_First_Name],[Title] ,[Taxonomy_Speciality],[Address1],[Address2],[City],[State]
,[Zip_Code],[County],[Phone],[Fax],[Email] ,[Website],[Payto_Address] ,[Payto_City] ,[Payto_State],[Payto_Zip_code],[Tax_Id])
VALUES
(@Enterprise_Name,@Organization_Type,@Owner_Last_Name,@Owner_First_Name,@Title,@Taxonomy_Speciality,@Address1,@Address2,
@City,@State,@Zip_Code,@County,@Phone,@Fax,@Email,@Website ,@Payto_Address,@Payto_City,@Payto_State,@Payto_Zip_code,@Tax_Id)" ;
DynamicParameters param = new DynamicParameters();
param.Add("@Enterprise_Name", Enterprise.Enterprise_Name);
param.Add("@Organization_Type", Enterprise.Organization_Type);
param.Add("@Owner_Last_Name", Enterprise.Owner_Last_Name);
param.Add("@Owner_First_Name", Enterprise.Owner_First_Name);
param.Add("@Title", Enterprise.Title);
param.Add("@Taxonomy_Speciality", Enterprise.Taxonomy_Speciality);
param.Add("@Address1", Enterprise.Address1);
param.Add("@Address2", Enterprise.Address2);
param.Add("@City", Enterprise.City);
param.Add("@State", Enterprise.State);
param.Add("@Zip_Code", Enterprise.Zip_Code);
param.Add("@County", Enterprise.County);
param.Add("@Phone", Enterprise.Phone);
param.Add("@Fax", Enterprise.Fax);
param.Add("@Email", Enterprise.Email);
param.Add("@Website", Enterprise.Website);
param.Add("@Payto_Address", Enterprise.Payto_Address);
param.Add("@Payto_City", Enterprise.Payto_City);
param.Add("@Payto_State", Enterprise.Payto_State);
param.Add("@Payto_Zip_code", Enterprise.Payto_Zip_code);
param.Add("@Tax_Id", Enterprise.Tax_Id);
param.Add("@ModifiedBy", Enterprise.ModifiedBy);
param.Add("@ModifiedByDate", Enterprise.ModifiedByDate.ToShortDateString());
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, param);
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public int UpdateEnterprise(Ent_Enterprise Enterprise)
{
int result = 0;
try
{
log.MethodLog("public int UpdateEnterprise(Ent_Enterprise Enterprise) method entry");
string Query = @"UPDATE [dbo].[Enterprise] SET
[Enterprise_Name]=@Enterprise_Name,[Organization_Type]= @Organization_Type ,[Owner_Last_Name]=@Owner_Last_Name,[Owner_First_Name]=@Owner_First_Name,
[Title]=@Title ,[Taxonomy_Speciality]=@Taxonomy_Speciality,[Address1]=@Address1,[Address2]=@Address2,[City]=@City,[State]=@State
,[Zip_Code]=@Zip_Code,[County]=@County,[Phone]=@Phone,[Fax]=@Fax,[Email]=@Email ,[Website]=@Website,[Payto_Address]=@Payto_Address ,
[Payto_City]=@Payto_City ,[Payto_State]=@Payto_State,[Payto_Zip_code]=@Payto_Zip_code,[Tax_Id]=@Tax_Id WHERE Enterprise_ID=@Enterprise_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Enterprise_ID", Enterprise.Enterprise_ID);
param.Add("@Enterprise_Name", Enterprise.Enterprise_Name);
param.Add("@Organization_Type", Enterprise.Organization_Type);
param.Add("@Owner_Last_Name", Enterprise.Owner_Last_Name);
param.Add("@Owner_First_Name", Enterprise.Owner_First_Name);
param.Add("@Title", Enterprise.Title);
param.Add("@Taxonomy_Speciality", Enterprise.Taxonomy_Speciality);
param.Add("@Address1", Enterprise.Address1);
param.Add("@Address2", Enterprise.Address2);
param.Add("@City", Enterprise.City);
param.Add("@State", Enterprise.State);
param.Add("@Zip_Code", Enterprise.Zip_Code);
param.Add("@County", Enterprise.County);
param.Add("@Phone", Enterprise.Phone);
param.Add("@Fax", Enterprise.Fax);
param.Add("@Email", Enterprise.Email);
param.Add("@Website", Enterprise.Website);
param.Add("@Payto_Address", Enterprise.Payto_Address);
param.Add("@Payto_City", Enterprise.Payto_City);
param.Add("@Payto_State", Enterprise.Payto_State);
param.Add("@Payto_Zip_code", Enterprise.Payto_Zip_code);
param.Add("@Tax_Id", Enterprise.Tax_Id);
param.Add("@ModifiedBy", Enterprise.ModifiedBy);
param.Add("@ModifiedByDate", Enterprise.ModifiedByDate.ToShortDateString());
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, param);
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
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 int DeletePayer(int PayerId)
{
int result = 0;
try
{
log.MethodLog(" public int DeletePayer(int PayerId) method entry");
string Query = "DELETE 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.ExecuteQuery(Query, param);
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public List <Ent_Provider> ViewAllProvider()
{
List <Ent_Provider> ent = null;
try
{
log.MethodLog(" public Ent_Provider ViewAllProvider() method entry");
//string Query = "SELECT * FROM Provider";
string procedure = "ViewAllProvider";
DynamicParameters param = new DynamicParameters();
log.MethodLog(procedure + "Passed to database");
ent = AtomORM.ExecuteProceduresReturnList <Ent_Provider>(procedure, param).ToList();
log.MethodLog(procedure + " procedure executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(ent);
}
public int DeleteFaclility(int FacilityId)
{
int result = 0;
try
{
log.MethodLog(" public int DeleteEnterprise(int FacilityId) method entry");
string Query = "DELETE FROM dbo.Facility WHERE Facility_ID=@Facility_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Facility_ID", FacilityId);
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, param);
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public Ent_Facility EditEnterprise(int FacilityId)
{
Ent_Facility result = null;
try
{
log.MethodLog(" public Ent_Facility EditEnterprise(int FacilityId) method entry");
string Query = "SELECT * FROM dbo.Facility WHERE Facility_ID=@Facility_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Facility_ID", FacilityId);
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQueryResult <Ent_Facility>(Query, param).FirstOrDefault();
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public Ent_Login login(Ent_Login login)
{
Ent_Login ent = null;
try
{
log.MethodLog(" public Ent_Login login(Ent_Login login) entry");
string Query = "SELECt * FROM dbo.Login WHERE UserName=@UserName AND Password=@Password";
DynamicParameters param = new DynamicParameters();
param.Add("@UserName", login.UserName);
param.Add("@Password", login.Password);
log.MethodLog(Query + "Passed to database");
ent = AtomORM.ExecuteQueryResult <Ent_Login>(Query, param).FirstOrDefault();
log.MethodLog("Quary executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(ent);
}
public List <DDLList> EnterpriseList()
{
List <DDLList> result = null;
try
{
log.MethodLog(" public int DeleteEnterprise(int Company_ID) method entry");
string Query = "SELECT Enterprise_ID AS Code,Enterprise_Name As Description FROM dbo.Enterprise ";
DynamicParameters param = new DynamicParameters();
log.MethodLog(Query + "Passed to database");
var res = AtomORM.ExecuteQueryResult <DDLList>(Query, param).ToList();
result = res;
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public Ent_Company EditCompany(int Company_ID)
{
Ent_Company result = null;
try
{
log.MethodLog(" public Ent_Company EditEnterprise(int Company_ID) method entry");
string Query = "SELECT * FROM dbo.Company WHERE Company_ID=@Company_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Company_ID", Company_ID);
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQueryResult <Ent_Company>(Query, param).FirstOrDefault();
result.EnterpriseList = EnterpriseList();
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public int AddFaclility(Ent_Facility Facility)
{
int result = 0;
try
{
log.MethodLog(" public int InsertintoEnterprise(Ent_Facility Facility) method entry");
string Query = @"INSERT INTO [dbo].[Facility]
([Company_ID] ,[Facility_Name],[Facility_Type],[NPI] ,[Taxonomy_Speciality],[Taxonomy_Description],[Sequence_Number],[Reference_Number],[Address1],[Address2],[City],[State]
,[Zip_Code],[Phone],[Fax],[Email] ,[Tax_ID],[Claim_ID] ,[Location_Provider_ID] ,[Site_ID],[Place_of_Service],[ModifiedBy],[ModifiedByDate])
VALUES
(@Company_ID,@Facility_Name,@Facility_Type,@NPI,@Taxonomy_Speciality,@Taxonomy_Description,@Sequence_Number,@Reference_Number,@Address1,@Address2,
@City,@State,@Zip_Code,@Phone,@Fax,@Email,@Tax_ID ,@Claim_ID,@Location_Provider_ID,@Site_ID,@Place_of_Service,@ModifiedBy,@ModifiedByDate)" ;
result = AtomORM.ExecuteQuery(Query, Assignparameters(Facility));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
public int UpdateFaclility(Ent_Facility Facility)
{
int result = 0;
try
{
log.MethodLog("public int UpdateEnterprise(Ent_Facility Facility) method entry");
string Query = @"UPDATE [dbo].[Facility] SET
[Company_ID]=@Company_ID ,[Facility_Name]=@Facility_Name,[Facility_Type]=@Facility_Type,[NPI]=@NPI ,[Taxonomy_Speciality]=@Taxonomy_Speciality
,[Taxonomy_Description]=Taxonomy_Description,[Address1]=@Address1,[Address2]=@Address2,[City]=@City,[State]=@State
,[Zip_Code]=@Zip_Code,[Phone]=@Phone,[Fax]=@Fax,[Email]=@Email ,[Tax_ID]=@Tax_ID,[Claim_ID]=@Claim_ID ,[Location_Provider_ID] =@Location_Provider_ID,
[Site_ID]=@Site_ID,[Place_of_Service]=@Place_of_Service,[ModifiedBy]=@ModifiedBy,[ModifiedByDate]=@ModifiedByDate";
log.MethodLog(Query + "Passed to database");
result = AtomORM.ExecuteQuery(Query, Assignparameters(Facility));
log.MethodLog("Query executed with out error");
}
catch (Exception ex)
{
log.ExceptionLog(ex);
}
return(result);
}
// GET: Employee
public ActionResult ViewAll()
{
//return View(AtomORM.ExecuteProceduresReturnList<Ent_Employee>("ViewAllEmployee"));
return(View(AtomORM.ExecuteQueryResult <Ent_Employee>("SELECT * FROM Employee").ToList()));
}
