/// <summary> /// Select Data of eq.ivp_polaris_securitysummary /// </summary> /// <param name="code">Code For Selecting Particular Table_Name.</param> /// <returns>List Of Objects</returns> public List <P_Eq_Ivp_Polaris_Securitysummary> SelectSectypeId(long code = 0) { try { List <P_Eq_Ivp_Polaris_Securitysummary> lstObj = new List <P_Eq_Ivp_Polaris_Securitysummary>(); string Query = "select * from eq.ivp_polaris_securitysummary"; if (code > 0) { Query += "where code = {0}"; Query = string.Format(Query, code); } DataTable dt = connect.returnDataset(Query).Tables[0]; foreach (DataRow row in dt.Rows) { P_Eq_Ivp_Polaris_Securitysummary tempObj = new P_Eq_Ivp_Polaris_Securitysummary(); tempObj._security_Id = Convert.ToInt64(row["security_Id"]); tempObj._securiry_Name = row["securiry_Name"].ToString(); tempObj._securiry_Description = row["securiry_Description"].ToString(); tempObj._has_Position = Convert.ToBoolean(row["has_Position"]); tempObj._is_Active = Convert.ToBoolean(row["is_Active"]); tempObj._round_Lot_Size = Convert.ToInt32(row["round_Lot_Size"]); tempObj._bloomberg_Unique_Name = row["bloomberg_Unique_Name"].ToString(); tempObj._created_By = row["created_By"].ToString(); tempObj._created_On = Convert.ToDateTime(row["created_On"]); tempObj._last_Modified_By = row["last_Modified_By"].ToString(); tempObj._last_Modified_On = Convert.ToDateTime(row["last_Modified_On"]); lstObj.Add(tempObj); } return(lstObj); } catch (Exception ex) { throw ex; } }
/// <summary> /// Delete Data in eq.ivp_polaris_securitysummary /// </summary> /// <param name="objClass">Object Of Class</param> /// <returns>Bool Value True- Success, False- Failure</returns> public bool DeleteSecuritySummary(P_Eq_Ivp_Polaris_Securitysummary objClass) { try { string Query = "Update eq.ivp_polaris_securitysummary set is_active = '{0}' where security_Id = {1}"; Query = string.Format(Query, objClass._is_Active, objClass._security_Id); if (connect.executeQuery(Query) > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }
/// <summary> /// Update Data in eq.ivp_polaris_securitysummary /// </summary> /// <param name="objClass">Object Of Class</param> /// <returns>Bool Value True- Success, False- Failure</returns> public bool UpdateSecuritySummary(P_Eq_Ivp_Polaris_Securitysummary objClass) { try { string Query = "update eq.ivp_polaris_securitysummary set securiry_name = '{0}',securiry_description = '{1}',has_position = '{2}',is_active = '{3}',round_lot_size = {4},bloomberg_unique_name = '{5}',created_by = '{6}',created_on = '{7}',last_modified_by = '{8}',last_modified_on = '{9}') " + " where security_Id = {10}"; Query = string.Format(Query, objClass._securiry_Name, objClass._securiry_Description, objClass._has_Position, objClass._is_Active, objClass._round_Lot_Size, objClass._bloomberg_Unique_Name, objClass._created_By, objClass._created_On, objClass._last_Modified_By, objClass._last_Modified_On, objClass._security_Id); if (connect.executeQuery(Query) > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }
/// <summary> /// Insert Data in eq.ivp_polaris_securitysummary /// </summary> /// <param name="objClass">Object Of Class</param> /// <returns>Bool Value True- Success, False- Failure</returns> public bool InsertSecuritySummary(P_Eq_Ivp_Polaris_Securitysummary objClass) { try { string Query = "insert into eq.ivp_polaris_securitysummary(securiry_name,securiry_description,has_position,is_active,round_lot_size,bloomberg_unique_name,created_by,created_on,last_modified_by,last_modified_on) " + "values('{0}','{1}','{2}','{3}',{4},'{5}','{6}','{7}','{8}','{9}')"; Query = string.Format(Query, objClass._securiry_Name, objClass._securiry_Description, objClass._has_Position, objClass._is_Active, objClass._round_Lot_Size, objClass._bloomberg_Unique_Name, objClass._created_By, objClass._created_On, objClass._last_Modified_By, objClass._last_Modified_On); if (connect.executeQuery(Query) > 0) { return(true); } return(false); } catch (Exception ex) { throw ex; } }