public string AddModifyTrackDetails(ClsTrackDetails ObjTrackDetails) { using (ClsTrackManagement_BAL obj = new ClsTrackManagement_BAL()) { return(obj.AddModifyTrackDetails(ObjTrackDetails)); } }
public string AddModifyTrackDetails(ClsTrackDetails ObjTrackDetails) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_Track_ID", ObjTrackDetails.Ref_Track_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Ref_Category_ID", ObjTrackDetails.Ref_Category_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@TrackType", ObjTrackDetails.TrackType, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@TrackName", ObjTrackDetails.TrackName, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Bio", ObjTrackDetails.Bio, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Mood", ObjTrackDetails.Mood, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Key", ObjTrackDetails.Key, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Tag", ObjTrackDetails.Tag, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@BMP", ObjTrackDetails.BMP, DbType.Int16); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@DAW", ObjTrackDetails.DAW, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Duration", ObjTrackDetails.Duration, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Price", ObjTrackDetails.Price, DbType.Decimal); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@PriceWithProjectFiles", ObjTrackDetails.PriceWithProjectFiles, DbType.Decimal); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@IsActive", ObjTrackDetails.IsActive, DbType.Boolean); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@IsVocals", ObjTrackDetails.IsVocals, DbType.Boolean); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@IsTrack", ObjTrackDetails.IsTrack, DbType.Boolean); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@TrackStatus", ObjTrackDetails.TrackStatus, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@CreatedBy", ObjTrackDetails.CreatedBy, DbType.String); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); Int64 Ref_Track_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyTrackDetails, ObJParameterCOl, CommandType.StoredProcedure)); if (Ref_Track_ID > 0) { ObjTrackDetails.FileManager.ForEach(File => { DBParameterCollection ObJParameterCOl1 = new DBParameterCollection(); DBParameter objDBParameter1 = new DBParameter("@FileManagerID", File.FileManagerID, DbType.Int64); ObJParameterCOl1.Add(objDBParameter1); objDBParameter1 = new DBParameter("@ModuleID", Ref_Track_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).ToString(); }); } if (Ref_Track_ID > 0 && ObjTrackDetails.Ref_Track_ID == 0) { return("TRACKADDED"); } else if (Ref_Track_ID > 0 && ObjTrackDetails.Ref_Track_ID > 0) { return("TRACKUPDATED"); } else { return("TRACKEXISTS"); } } catch (Exception ex) { throw ex; } }