public string AddModifyServiceDetails(ClsServiceDetails ObjServiceDetails) { using (ClsServiceManagement_BAL obj = new ClsServiceManagement_BAL()) { return(obj.AddModifyServiceDetails(ObjServiceDetails)); } }
public string AddModifyServiceDetails(ClsServiceDetails ObjServiceDetails) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_Service_ID", ObjServiceDetails.Ref_Service_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Ref_Category_ID", ObjServiceDetails.Ref_Category_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@AliasName", ObjServiceDetails.AliasName, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@ServiceTitle", ObjServiceDetails.ServiceTitle, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Description", ObjServiceDetails.Description, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@DeliveryDate", ObjServiceDetails.DeliveryDate, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Price", ObjServiceDetails.Price, DbType.Decimal); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@PriceWithProjectFiles", ObjServiceDetails.PriceWithProjectFiles, DbType.Decimal); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Revision", ObjServiceDetails.Revision, DbType.Int32); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Ref_User_ID", ObjServiceDetails.Ref_User_ID, DbType.Int32); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@MetaTitle", ObjServiceDetails.MetaTitle, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@MetaKeywords", ObjServiceDetails.MetaKeywords, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@MetaDescription", ObjServiceDetails.MetaDescription, DbType.String); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); Int64 Ref_Service_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyServiceDetails, ObJParameterCOl, CommandType.StoredProcedure)); if (Ref_Service_ID > 0) { ObjServiceDetails.FileManager.ForEach(File => { DBParameterCollection ObJParameterCOl1 = new DBParameterCollection(); DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@ModuleID", Ref_Service_ID, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@ModuleType", File.ModuleType, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileIdentifier", File.FileIdentifier, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileName", File.FileName, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FilePath", File.FilePath, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileExtension", File.FileExtension, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileType", File.FileType, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileSize", File.FileSize, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@FileSequence", File.Sequence, DbType.Int32); ObJParameterCOl1.Add(objDBParameter1); objDbHelper.ExecuteScalar(Constant.SaveModuleFile, ObJParameterCOl1, CommandType.StoredProcedure); }); ObjServiceDetails.FAQDetails.ForEach(FAQ => { DBParameterCollection ObJParameterCOl1 = new DBParameterCollection(); DBParameter objDBParameter1 = new DBParameter("@Ref_Service_ID", Ref_Service_ID, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@Question", FAQ.Questions, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@Answer", FAQ.Answer, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@Ref_User_ID", ObjServiceDetails.Ref_User_ID, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@CreatedName", ObjServiceDetails.CreatedName, DbType.String); ObJParameterCOl1.Add(objDBParameter1); objDbHelper.ExecuteScalar(Constant.AddModifyServiceFAQ, ObJParameterCOl1, CommandType.StoredProcedure); }); } if (Ref_Service_ID > 0 && ObjServiceDetails.Ref_Service_ID == 0) { return("SERVICEADDED"); } else if (Ref_Service_ID > 0 && ObjServiceDetails.Ref_Service_ID > 0) { return("SERVICEUPDATED"); } else { return("SERVICEEXISTS"); } } catch (Exception ex) { throw ex; } }