public ActionResult Facility(Ent_Facility Facility)
{
Facility.ModifiedBy = Session["UserName"].ToString();
Facility.ModifiedByDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (Facility.Facility_ID == 0)
{
bll.AddFaclility(Facility);
}
else
{
bll.UpdateFaclility(Facility);
}
return(RedirectToAction("ViewAllFacility"));
}
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 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);
}
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 DynamicParameters Assignparameters(Ent_Facility Facility)
{
try
{
DynamicParameters param = new DynamicParameters();
param.Add("@Company_ID", 1);
param.Add("@Facility_Name", Facility.Facility_Name);
param.Add("@Facility_Type", Facility.Facility_Type);
param.Add("@NPI", Facility.NPI);
param.Add("@Taxonomy_Speciality", Facility.Taxonomy_Speciality);
param.Add("@Taxonomy_Description", Facility.Taxonomy_Description);
param.Add("@Sequence_Number", Facility.Sequence_Number);
param.Add("@Reference_Number", Facility.Reference_Number);
param.Add("@Address1", Facility.Address1);
param.Add("@Address2", Facility.Address2);
param.Add("@City", Facility.City);
param.Add("@State", Facility.State);
param.Add("@Zip_Code", Facility.Zip_Code);
param.Add("@Phone", Facility.Phone);
param.Add("@Fax", Facility.Fax);
param.Add("@Email", Facility.Email);
param.Add("@Tax_ID", Facility.Tax_ID);
param.Add("@Claim_ID", Facility.Claim_ID);
param.Add("@Location_Provider_ID", Facility.Location_Provider_ID);
param.Add("@Site_ID", Facility.Site_ID);
param.Add("@Locater_Code", Facility.Locater_Code);
param.Add("@Place_of_Service", Facility.Place_of_Service);
param.Add("@ModifiedBy", Facility.ModifiedBy);
param.Add("@ModifiedByDate", Facility.ModifiedByDate.ToShortDateString());
return(param);
}
catch (Exception)
{
throw;
}
}
