//Update Reference Group
public bool UpdateReferenceGroup(eSunSpeedDomain.ReferenceGroupModel objrefGrp)
{
string Query = string.Empty;
bool IsUpdate = false;
DBParameterCollection paramCollection = new DBParameterCollection();
try
{
paramCollection.Add(new DBParameter("@Name", objrefGrp.Name));
paramCollection.Add(new DBParameter("@CreatedBy", string.Empty));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ReferenceId", objrefGrp.ReferenceId));
Query = "UPDATE Referencegroup SET Name=@Name,CreatedBy=@CreatedBy,CreatedDate=@CreatedDate,ModifiedBy=@ModifiedBy,ModifiedDate=@ModifiedDate " +
"WHERE RG_ID=@ReferenceId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
IsUpdate = true;
}
}
catch (Exception ex)
{
IsUpdate = false;
throw ex;
}
return(IsUpdate);
}
/// <summary>
/// Save Reference Group
/// </summary>
/// <param name="objReferenceGroup"></param>
/// <returns>True/False</returns>
public bool SaveReferenceGroup(eSunSpeedDomain.ReferenceGroupModel objrefGrp)
{
string Query = string.Empty;
bool IsSaved = false;
DBParameterCollection paramCollection = new DBParameterCollection();
try
{
paramCollection.Add(new DBParameter("@Name", objrefGrp.Name));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", string.Empty));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
Query = "INSERT INTO Referencegroup(`Name`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`) VALUES (@Name,@CreatedBy,@CreatedDate,@ModifiedBy,@ModifiedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
IsSaved = true;
}
}
catch (Exception ex)
{
IsSaved = false;
throw ex;
}
return(IsSaved);
}
/// <summary>
/// Save Account Group
/// </summary>
/// <param name="objAccountGrp"></param>
/// <returns>True/False</returns>
public bool SaveReferenceGroup(eSunSpeedDomain.ReferenceGroupModel objrefGrp)
{
string Query = string.Empty;
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Name", objrefGrp.Name));
//paramCollection.Add(new DBParameter("@AliasName", objAccountGrp.AliasName));
//paramCollection.Add(new DBParameter("@Primary", objAccountGrp.Primary));
//paramCollection.Add(new DBParameter("@UnderGroup", objAccountGrp.UnderGroup));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO Referencegroup(`Name`,`CreatedBy`) VALUES (@Name,@CreatedBy)";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}