private List <SqlParameter> Set_Values_In_Attachment(AttachmentsInfo attachment) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Ref_Id", attachment.Ref_Id)); sqlParams.Add(new SqlParameter("@Ref_Type", attachment.Ref_Type)); sqlParams.Add(new SqlParameter("@Document_Name", attachment.Document_Name)); sqlParams.Add(new SqlParameter("@CreatedBy", attachment.CreatedBy)); sqlParams.Add(new SqlParameter("@CreatedOn", attachment.CreatedOn)); sqlParams.Add(new SqlParameter("@UpdatedBy", attachment.UpdatedBy)); sqlParams.Add(new SqlParameter("@UpdatedOn", attachment.UpdatedOn)); sqlParams.Add(new SqlParameter("@Remark", attachment.Remark)); // return(sqlParams); }
private AttachmentsInfo Get_Attachments_Values(DataRow dr) { AttachmentsInfo attachments = new AttachmentsInfo(); attachments.Attachment_Id = Convert.ToInt64(dr["Attachment_Id"]); attachments.Ref_Id = Convert.ToInt32(dr["Ref_Id"]); attachments.Ref_Type = Convert.ToInt32(dr["Ref_Type"]); attachments.Document_Name = Convert.ToString(dr["Document_Name"]); attachments.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); attachments.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]); attachments.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]); attachments.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]); //attachments.Remark = Convert.ToString(dr["Remark"]); return(attachments); }
public JsonResult View_Attachment_By_Id(int Attachment_Id) { AttachmentsInfo attachment = new AttachmentsInfo(); try { attachment = _attachmentsMan.Get_Attachment_By_Id(Attachment_Id); attachment.Unique_Id = ConfigurationManager.AppSettings["Upload_Image_Path"].ToString() + @"\" + attachment.File_Type_Str + @"\" + attachment.Unique_Id; } catch (Exception ex) { Logger.Error("Error : " + ex.ToString()); } return(Json(attachment, JsonRequestBehavior.AllowGet)); }
private AttachmentsInfo Get_Attachments_Values(DataRow dr) { AttachmentsInfo attachments = new AttachmentsInfo(); attachments.Attachment_Id = Convert.ToInt32(dr["Attachment_Id"]); attachments.File_Name = Convert.ToString(dr["File_Name"]); attachments.Unique_Id = Convert.ToString(dr["Unique_Id"]); attachments.File_Type = Convert.ToInt32(dr["File_Type"]); attachments.Is_Active = Convert.ToBoolean(dr["Is_Active"]); attachments.Created_By = Convert.ToInt32(dr["Created_By"]); attachments.Updated_By = Convert.ToInt32(dr["Updated_By"]); attachments.Created_On = Convert.ToDateTime(dr["Created_On"]); attachments.Updated_On = Convert.ToDateTime(dr["Updated_On"]); return(attachments); }
private List <SqlParameter> Set_Values_In_Attachments(AttachmentsInfo attachment) { List <SqlParameter> sqlParams = new List <SqlParameter>(); //sqlParams.Add(new SqlParameter("@Attachment_Id", attachments.Attachment_Id)); sqlParams.Add(new SqlParameter("@File_Name", attachment.File_Name)); sqlParams.Add(new SqlParameter("@Unique_Id", attachment.Unique_Id)); sqlParams.Add(new SqlParameter("@File_Type", attachment.File_Type)); sqlParams.Add(new SqlParameter("@Is_Active", attachment.Is_Active)); sqlParams.Add(new SqlParameter("@Created_By", attachment.Created_By)); sqlParams.Add(new SqlParameter("@Updated_By", attachment.Updated_By)); sqlParams.Add(new SqlParameter("@Created_On", attachment.Created_On)); sqlParams.Add(new SqlParameter("@Updated_On", attachment.Updated_On)); return(sqlParams); }
public CustomerQualityViewModel() { Friendly_Message = new List <FriendlyMessageInfo>(); Pager = new PaginationInfo(); Customer_Quality = new CustomerQualityInfo(); Customer_Qualities = new List <CustomerQualityInfo>(); Filter = new CustomerQualityFilter(); Attachment = new AttachmentsInfo(); Attachments = new List <AttachmentsInfo>(); }
public AttachmentsInfo Get_Attachment_By_Id(int Attachment_Id) { AttachmentsInfo attachment = new AttachmentsInfo(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Attachment_Id", Attachment_Id)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Attachment_By_Id_Sp.ToString(), CommandType.StoredProcedure); List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { attachment = Get_Attachments_Values(dr); } return(attachment); }
public List <AttachmentsInfo> Get_Attachment_By_Type(ref PaginationInfo pager, int File_Type) { List <AttachmentsInfo> attachments = new List <AttachmentsInfo>(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@File_Type", File_Type)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Attachments_By_File_Type_Sp.ToString(), CommandType.StoredProcedure); foreach (DataRow dr in CommonMethods.GetRows(dt, ref pager)) { AttachmentsInfo attachment = new AttachmentsInfo(); attachment = Get_Attachments_Values(dr); attachment.Unique_Id = ConfigurationManager.AppSettings["Upload_Image_Path"].ToString() + @"\" + attachment.File_Type_Str + @"\" + attachment.Unique_Id; //attachments.Add(Get_Attachments_Values(dr)); attachments.Add(attachment); } return(attachments); }
public JsonResult Delete_Attachment(long attachment_Id) { List <FriendlyMessageInfo> Friendly_Message = new List <FriendlyMessageInfo>(); AttachmentsInfo attachments = new AttachmentsInfo(); try { AjaxManager aMan = new AjaxManager(); attachments = aMan.Get_Attachment_By_Id(attachment_Id); var saveToFileLoc = string.Format("{0}\\{1}", Server.MapPath("/uploads/" + attachments.Ref_Type_Str + "/" + attachments.Ref_Id), attachments.Document_Name); if (saveToFileLoc != null || saveToFileLoc != string.Empty) { if ((System.IO.File.Exists(saveToFileLoc))) { System.IO.File.Delete(saveToFileLoc); } } aMan.Delete_Attachment_By_Id(attachment_Id); Friendly_Message.Add(MessageStore.Get("AJ002")); } catch (Exception ex) { Friendly_Message.Add(MessageStore.Get("SYS01")); Logger.Error("Ajax Controller - Delete_Attachment " + ex.ToString()); } return(Json(new { Friendly_Message }, JsonRequestBehavior.AllowGet)); }
public void Insert_Attachment(AttachmentsInfo attachment) { _attachmentsRepo.Insert_Attachment(attachment); }
public long Insert_Attachment(AttachmentsInfo attachment) { return(_ajaxRepo.Insert_Attachment(attachment)); }
public long Insert_Attachment(AttachmentsInfo attachment) { long attachemnt_Id = Convert.ToInt64(sqlRepo.ExecuteScalerObj(Set_Values_In_Attachment(attachment), StoredProcedures.Insert_Attachment_Sp.ToString(), CommandType.StoredProcedure)); return(attachemnt_Id); }
public void Insert_Attachment(AttachmentsInfo attachment) { _sqlRepo.ExecuteNonQuery(Set_Values_In_Attachments(attachment), StoredProcedures.Insert_Attachments_Sp.ToString(), CommandType.StoredProcedure); }