public string AddPharmacy(PriorAuthPhmc objPrior, string loginId)
{
string result = "";
try
{
string query = string.Format(dbQueries.sqlAddPharPriorAuth, loginId);
SqlParameter[] sqlParameter = new SqlParameter[17];
sqlParameter[0] = new SqlParameter(DBQueries.sqlPrm_phid, System.Data.SqlDbType.VarChar);
sqlParameter[0].Value = objPrior.PHARMACY_CODE;
sqlParameter[1] = new SqlParameter(DBQueries.sqlPrm_phcode, System.Data.SqlDbType.VarChar);
sqlParameter[1].Value = objPrior.PHARMACY_CODE;
sqlParameter[2] = new SqlParameter(DBQueries.sqlPrm_cid, System.Data.SqlDbType.VarChar);
sqlParameter[2].Value = objPrior.CORP_ID;
sqlParameter[3] = new SqlParameter(DBQueries.sqlPrm_regid, System.Data.SqlDbType.VarChar);
sqlParameter[3].Value = objPrior.REGION_ID;
sqlParameter[4] = new SqlParameter(DBQueries.sqlPrm_regname, System.Data.SqlDbType.VarChar);
sqlParameter[4].Value = objPrior.REGION_NAME ?? (object)DBNull.Value;
sqlParameter[5] = new SqlParameter(DBQueries.sqlPrm_addr1, System.Data.SqlDbType.VarChar);
sqlParameter[5].Value = objPrior.ADDR_L1 ?? (object)DBNull.Value;
sqlParameter[6] = new SqlParameter(DBQueries.sqlPrm_addr2, System.Data.SqlDbType.VarChar);
sqlParameter[6].Value = objPrior.ADDR_L2 ?? (object)DBNull.Value;
sqlParameter[7] = new SqlParameter(DBQueries.sqlPrm_city, System.Data.SqlDbType.VarChar);
sqlParameter[7].Value = objPrior.CITY ?? (object)DBNull.Value;
sqlParameter[8] = new SqlParameter(DBQueries.sqlPrm_state, System.Data.SqlDbType.VarChar);
sqlParameter[8].Value = objPrior.STATE ?? (object)DBNull.Value;
sqlParameter[9] = new SqlParameter(DBQueries.sqlPrm_plusfour, System.Data.SqlDbType.VarChar);
sqlParameter[9].Value = objPrior.PLUS_FOUR ?? (object)DBNull.Value;
sqlParameter[10] = new SqlParameter(DBQueries.sqlPrm_pnumber, System.Data.SqlDbType.VarChar);
sqlParameter[10].Value = objPrior.PHONE_NUM ?? (object)DBNull.Value;
sqlParameter[11] = new SqlParameter(DBQueries.sqlPrm_active, System.Data.SqlDbType.Bit);
sqlParameter[11].Value = objPrior.ACTIVE_IND == true ? 1 : 0;
//sqlParameter[12] = new SqlParameter(DBQueries.sqlprm_excludedmetrics, System.Data.SqlDbType.VarChar);
//sqlParameter[12].Value = objPrior.ExcludeFromMetrics == true ? 1 : 0;
sqlParameter[12] = new SqlParameter(DBQueries.sqlPrm_manualflag, System.Data.SqlDbType.VarChar);
sqlParameter[12].Value = objPrior.MANUALFLAG == true ? 1 : 0;
sqlParameter[13] = new SqlParameter(DBQueries.sqlPrm_faxnum, System.Data.SqlDbType.VarChar);
sqlParameter[13].Value = objPrior.FAX_NUM ?? (object)DBNull.Value;
sqlParameter[14] = new SqlParameter(DBQueries.sqlprm_phname, System.Data.SqlDbType.VarChar);
sqlParameter[14].Value = objPrior.PHARMACY_NAME ?? (object)DBNull.Value;
sqlParameter[15] = new SqlParameter(DBQueries.sqlPrm_phdesc, System.Data.SqlDbType.VarChar);
sqlParameter[15].Value = objPrior.PHARMACY_NAME ?? (object)DBNull.Value;
sqlParameter[16] = new SqlParameter(DBQueries.sqlPrm_zip, System.Data.SqlDbType.VarChar);
sqlParameter[16].Value = objPrior.ZIP ?? (object)DBNull.Value;
result = ExecuteSP("PriorAuth", query, sqlParameter);
}
catch (Exception ex)
{
return("Please try after some time, If it repeats please reach support team.");
}
return(result);
}
public ActionResult PharmacyCreation(string view)
{
switch (view)
{
case "ViewMasterPhmc":
return(View("ViewMasterPhmc", new ViewMasterPhmc()));
case "EcensusPhmc":
return(View("EcensusPhmc", new EcensusPhmc()));
case "EmanifestPhmc":
return(View("EmanifestPhmc", new EmanifestPhmc()));
case "PharmericaCommPhmc":
return(View("PharmericaCommPhmc", new PharmericaCommPhmc()));
case "PriorAuthPhmc":
PriorAuthPhmc objPrior = new PriorAuthPhmc();
objPrior.ListRegions = dbCommon.GetList("Regions", "SNT");
objPrior.ListCorps = dbCommon.GetList("Corps", "SNT");
return(View("PriorAuthPhmc", objPrior));
case "RealTimeDataMartPhmc":
SNT objSNT = new SNT();
objSNT.ListSqlConnections = dbCommon.GetListFromXml("SntSqlConnection");
objSNT.ListCorps = dbCommon.GetList("Corps", "SNT");
objSNT.ListRegions = dbCommon.GetList("Regions", "SNT");
objSNT.Districts = dbCommon.GetList("Districts", "SNT");
objSNT.TimeZones = dbCommon.GetList("TimeZones", "SNT"); objSNT.PharTimeZones = dbCommon.GetList("PhrTimeZones", "SNT");
return(View("RealTimeDataMartPhmc", objSNT));
case "DocuTrackPhmc":
DocuTrackPhmc objDoc = new DocuTrackPhmc();
objDoc.SqlConnections = dbCommon.GetListFromXml("DocSqlConnec");
return(View("DocuTrackPhmc", objDoc));
default:
return(View("404"));
}
}
public ActionResult AddPriorAuthPharmacy(PriorAuthPhmc objPriorAuth)
{
TempData["data"] = "";
if (ModelState.IsValid)
{
TempData["data"] = dbCommon.AddPharmacy(objPriorAuth, getUserId());
}
if (TempData["data"].ToString() == DBQueries.msgPharmacyCreationSuccess)
{
return(RedirectToAction("PharmacyCreation", new { view = "PriorAuthPhmc" }));
}
else
{
objPriorAuth.ListRegions = dbCommon.GetList("Regions", "SNT");
//objPrior.Districts = dbCommon.GetList("Districts");
objPriorAuth.ListCorps = dbCommon.GetList("Corps", "SNT"); //objPrior.PharTimeZones = dbCommon.GetList("PhrTimeZones");
int REGION_ID = Convert.ToInt16(objPriorAuth.REGION_ID);
objPriorAuth.REGION_NAME = objPriorAuth.ListCorps.Where(s => s.Id == REGION_ID).SingleOrDefault().Name;
return(View("PriorAuthPhmc", objPriorAuth));
}
}
