Beispiel #1
0
        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());
        }
Beispiel #2
0
 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));
     }
 }
Beispiel #3
0
        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"));
            }
        }