/// <summary>
/// List of Account Groups
/// </summary>
/// <returns>List of Groups</returns>
public List <eSunSpeedDomain.AccountGroupModel> GetListofAccountsGroups()
{
List <eSunSpeedDomain.AccountGroupModel> lstAccountGroups = new List <eSunSpeedDomain.AccountGroupModel>();
eSunSpeedDomain.AccountGroupModel accountGroup;
string Query = "SELECT DISTINCT AG_ID,CanDelete,GroupName,AliasName,primary, UnderGroup FROM AccountGroups where UnderGroup<>''";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
accountGroup = new eSunSpeedDomain.AccountGroupModel();
accountGroup.GroupId = Convert.ToInt32(dr["AG_ID"]);
accountGroup.CanDelete = Convert.ToBoolean(dr["CanDelete"]);
accountGroup.GroupName = dr["GroupName"].ToString();
accountGroup.AliasName = dr["AliasName"].ToString();
accountGroup.UnderGroup = dr["UnderGroup"].ToString();
accountGroup.Primary = dr["Primary"].ToString();
lstAccountGroups.Add(accountGroup);
}
return(lstAccountGroups);
}
/// <summary>
/// Modified Account Group
/// </summary>
/// <param name="objAccountGroup"></param>
/// <returns>True/False</returns>
public bool UpdateAccountGroup(eSunSpeedDomain.AccountGroupModel objAccountGroup)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@GroupName", objAccountGroup.GroupName));
paramCollection.Add(new DBParameter("@AliasName", objAccountGroup.AliasName));
paramCollection.Add(new DBParameter("@Primary", objAccountGroup.Primary));
paramCollection.Add(new DBParameter("@UnderGroup", objAccountGroup.UnderGroup));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@GroupId", objAccountGroup.GroupId));
Query = "UPDATE AccountGroups SET [GroupName]=@GroupName,[AliasName]=@AliasName,[Primary]=@Primay,[UnderGroup]=@UnderGroup,[ModifiedBy]=@ModifiedBy " +
"WHERE [AG_ID]=@GroupId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
/// <summary>
/// Save Account Group
/// </summary>
/// <param name="objAccountGrp"></param>
/// <returns>True/False</returns>
public bool SaveAccountGroup(eSunSpeedDomain.AccountGroupModel objAccountGrp)
{
string Query = string.Empty;
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@GroupName", objAccountGrp.GroupName));
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", objAccountGrp.CreatedBy));
Query = "INSERT INTO AccountGroups(`AG_ID`,`GroupName`,`AliasName`,`Primary`,`UnderGroup`,`CreatedBy`) VALUES (2,@GroupName,@AliasName,@Primary,@UnderGroup,@CreatedBy)";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}
private void btnSave_Click(object sender, EventArgs e)
{
//TODO: 1. Check whether the group name exists or not
//2. if exist then do not allow to save with the same group name
//3. Prompt user to change the group name as it already exists
if (tbxGroupName.Text.Equals(string.Empty))
{
MessageBox.Show("Group Name can not be blank!");
return;
}
if (accObj.IsGroupExists(tbxGroupName.Text.Trim()))
{
MessageBox.Show("Group Name already Exists!", "SunSpeed", MessageBoxButtons.RetryCancel);
// cbxUnderGrp.Focus();
return;
}
eSunSpeedDomain.AccountGroupModel objAccGroup = new eSunSpeedDomain.AccountGroupModel();
objAccGroup.GroupName = tbxGroupName.Text;
objAccGroup.AliasName = tbxAliasname.Text;
objAccGroup.Primary = cbxPrimarygroup.SelectedItem.ToString();
objAccGroup.UnderGroup = cbxPrimarygroup.SelectedItem.ToString().Equals("Yes") ? "" : cbxUndergroup.SelectedItem.ToString();
objAccGroup.CreatedBy = "Admin";
string message = string.Empty;
bool isSuccess = accObj.SaveAccountGroup(objAccGroup);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
}
//List<eSunSpeedDomain.AccountGroupModel> lstGroups = accObj.GetListofAccountsGroups();
//dgvList.DataSource = lstGroups;
//Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
//d.ShowDialog();
}