public string AddPharmacy(DocuTrackPhmc pcm) { string result = ""; try { string query = dbQueries.sqlAddPh_DocuTrack; SqlParameter[] sqlParameter = new SqlParameter[6]; sqlParameter[0] = new SqlParameter(DBQueries.sqlPrm_phcode, System.Data.SqlDbType.VarChar); sqlParameter[0].Value = pcm.PharmericaPharmacyCode; sqlParameter[1] = new SqlParameter(DBQueries.sqlPrm_folderId, System.Data.SqlDbType.VarChar); sqlParameter[1].Value = pcm.DocuTrackFolderId; sqlParameter[2] = new SqlParameter(DBQueries.sqlPrm_connectionstring, System.Data.SqlDbType.VarChar); sqlParameter[2].Value = pcm.DocuTrackSqlConnectionString; sqlParameter[3] = new SqlParameter(DBQueries.sqlPrm_webServiceUri, System.Data.SqlDbType.VarChar); sqlParameter[3].Value = pcm.DocuTrackWebServiceUri; sqlParameter[4] = new SqlParameter(DBQueries.sqlPrm_active, System.Data.SqlDbType.VarChar); sqlParameter[4].Value = pcm.Active == true ? 1 : 0; sqlParameter[5] = new SqlParameter(DBQueries.sqlPrm_version, System.Data.SqlDbType.VarChar); sqlParameter[5].Value = pcm.DocuTrackVersion ?? (object)DBNull.Value; result = ExecuteSP("Docutrack", query, sqlParameter); } catch (Exception ex) { return("Please try after some time, If it repeats please reach support team."); } return(result.ToString()); }
public ActionResult AddPharmDocuTrack(DocuTrackPhmc docuTrackCommPhmc) { TempData["data"] = ""; if (ModelState.IsValid) { TempData["data"] = dbCommon.AddPharmacy(docuTrackCommPhmc); } if (TempData["data"].ToString() == DBQueries.msgPharmacyCreationSuccess) { return(RedirectToAction("PharmacyCreation", new { view = "DocuTrackPhmc" })); } else { docuTrackCommPhmc.SqlConnections = dbCommon.GetListFromXml("DocSqlConnec"); return(View("DocuTrackPhmc", docuTrackCommPhmc)); } }
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")); } }