public SavingState SaveSrDsr(SRDSR srDsr)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(srDsr.Name) && !string.IsNullOrEmpty(srDsr.CellNo))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
/// if new sr
if (string.IsNullOrEmpty(srDsr.Id))
{
if (!IsSRDSRExist(srDsr.Name, srDsr.CellNo))
{
thisCommand.CommandText = "INSERT INTO IM_SR_DSR (Id, Name, Type, CellNo) VALUES(@Id, @Name, @Type, @CellNo)";
CreateParameter.AddParam(thisCommand, "@Id", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
thisCommand.CommandText = "UPDATE IM_SR_DSR SET Name = @Name, Type = @Type, CellNo = @CellNo WHERE Id = @Id";
CreateParameter.AddParam(thisCommand, "@Id", srDsr.Id, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@Name", srDsr.Name, DbType.String);
CreateParameter.AddParam(thisCommand, "@Type", (int)srDsr.Type, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@CellNo", srDsr.CellNo, DbType.String);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
return(svState);
}
private SRDSR MapSrDsr(DbDataReader dr)
{
SRDSR srDsr = new SRDSR();
srDsr.Id = NullHandler.GetString(dr["Id"]);
srDsr.Name = NullHandler.GetString(dr["Name"]);
srDsr.Type = (SRType)NullHandler.GetInt32(dr["Type"]);
srDsr.CellNo = NullHandler.GetString(dr["CellNo"]);
return(srDsr);
}
