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)); } }