public ActionResult Company(Ent_Company com)
{
com.ModifiedBy = Session["UserName"].ToString();
com.ModifiedByDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
if (com.Enterprise_ID == 0)
{
bll.AddComapny(com);
}
else
{
bll.UpdateCompany(com);
}
return(RedirectToAction("ViewAllCompany"));
}
public ActionResult Company(int id = 0)
{
if (id != 0)
{
return(View(bll.EditCompany(id)));
}
else
{
Ent_Company com = new Ent_Company();
com.EnterpriseList = bll.EnterpriseList();
return(View(com));
}
}
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 UpdateCompany(Ent_Company Company)
{
int result = 0;
try
{
log.MethodLog("public int UpdateEnterprise(Ent_Company Company) method entry");
string Query = @"UPDATE [dbo].[Company] SET
[Company_Name]=@Company_Name,[Organization_Type]= @Organization_Type,[Taxonomy_Speciality]=@Taxonomy_Speciality,[Address1]=@Address1,[Address2]=@Address2,[City]=@City,[State]=@State
,[Zip_Code]=@Zip_Code,[Country]=@Country,[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, [NPI]=@NPI WHERE Enterprise_ID=@Enterprise_ID";
DynamicParameters param = new DynamicParameters();
param.Add("@Company_Name", Company.Company_Name);
param.Add("@Organization_Type", Company.OrganizationType);
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 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);
}
